Video: Designing Stored Procedure Solutions
My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code!...
2014-04-28
1,234 reads
Jen McCown
MidnightDBA at SQL Saturday Houston – May 10
Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735...
2014-04-14
638 reads
Heartbleed bug: immediate security threat for both IT, and consumer sites and services
“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...
2014-04-10
694 reads
Decree: Set your partition offset and block size – make SQL Server faster
If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB...
2014-04-07
1,494 reads
GetLogSpace – table and stored procedure
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote...
2014-03-31
1,252 reads
SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA
We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an...
2014-03-26
614 reads
The problem with PASS Summit abstracts (and submissions and selection and notification and…)
The problem with the PASS Summit session submissions process is that people don’t know why they’re rejected. So say we...
2014-03-26 (first published: 2014-03-19)
1,438 reads
The case for SQL Server 2012 Enterprise (vs. Standard) edition
In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are...
2014-03-24
1,036 reads
InfoWorld Review: SQL Server 2014, by Sean McCown
InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal...
2014-03-20
711 reads
Breaking: SQL Server 2014 RTM in two weeks
Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted...
2014-03-18
815 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers