Premium Database on Azure
One of the things that can make Windows Azure SQL Databases (WASD) attractive is the fact that they run inside...
2013-09-24
761 reads
Blog Posts
SQL Server Diagnostic Information Queries for September 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-09-24
1,181 reads
SQL Server Hardware and Storage Links
Being a DBA is more than just knowing about SQL: it’s about the technology which SQL runs on, which includes servers and storage. I’m naturally interested in hardware, so...
2013-09-24
3 reads
SQL Server Internals Presentation with PASS DC Chapter October 10, 2013
If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join...
2013-09-24
518 reads
Why the Lazy Spool Is Bad
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,577 reads
Cumulative update package 6 for SQL Server 2012 SP1
Microsoft has release the CU update package 6 for SQL Server 2012 SP1. To apply this package in your environment,...
2013-09-23
1,328 reads
Encryption and Full Text Search at The Mandalay Bay (DevConnections)
It’s just a week until Dev Connections. This is one of the great conferences for the hybrid technology person, with...
2013-09-23
679 reads
Finding The Active Sharepoint Databases
This was a task from last week. There was a server where we wanted to make some adjustments to security...
2013-09-23
949 reads
Installing SQL Server 2008 on a machine with .NET Framework 4.0? Read this.
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,064 reads
It's Just Another Manic SUNDAY - OT
Warning, this is just a non-technical anecdotal blog of a silly time-warp incident that happened to me yesterday. Thought it...
2013-09-23
874 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...
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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