SQL Saturday NYC Update #4
SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th. Before...
2015-02-21
776 reads
Blog Posts
A .Net Developers Favorite Learning Resources
At a recent Brighton Alt.Net the question came up “What learning resources do people use to continuously learn?”, as a...
2015-02-20
55 reads
A Critical SQL Server 2014 Cumulative Update
If you are running SQL Server 2014, please read the following:
Memory leak occurs when you run DBCC CHECKDB against a...
2015-02-20
263 reads
A Critical SQL Server 2014 Cumulative Update
If you are running SQL Server 2014, please read the following:
Memory leak occurs when you run DBCC CHECKDB against a...
2015-02-20
761 reads
Excel BI Tip #20: Wingdings–an Excel Services Supported Indicator Alternative
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-20 (first published: 2015-02-10)
7,171 reads
Friday Followup For February 20, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-02-20
429 reads
SQL Saturday NYC Update #3
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-02-20
252 reads
Easy way to diagnose SQL Server “sp_Who2” TIP #84
Why the SQL Server is running slow ?
What are the processes running currently on SQL SERVER instance ?
Many other like...
2015-02-19
434 reads
Powershell Quick Parameters for Scripts
I was working on a script recently to manage a particular process and wanted to make it generic by allowing...
2015-02-19
1,185 reads
Source control isnt just a backup
In the second part of this series on getting more agile and bringing our Sql Server development practices up to...
2015-02-19
39 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