Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine...
2014-11-11 (first published: 2014-11-06)
7,413 reads
Blog Posts
#SQLPASS #Summit14 Day 2 Keynote Highlights !
This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...
2014-11-10
851 reads
Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...
2014-11-10
7 reads
Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2....
2014-11-10
4,000 reads
Expected Variables–T-SQL Testing
After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...
2014-11-10
734 reads
How explicitly insert default value ? TIP #72
Suppose, sometimes you just need entry in the table with all the default values.
For example you have a Student...
2014-11-10
210 reads
Last Weeks Top “Reading” Links #108
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-10
331 reads
Let’s get started
Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...
2014-11-10
474 reads
Monitoring BI Performance: Scripts and Slides
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...
2014-11-10
1,245 reads
PASS Keynote–Dr. Rimma Nehme
I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.
We begin with a...
2014-11-10 (first published: 2014-11-06)
5,324 reads
Blogs
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...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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