Exam Prep 70-463: Variables and Parameters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-10 (first published: 2015-02-23)
8,063 reads
Blog Posts
Monitor Query Statistics
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....
2015-03-10 (first published: 2015-02-26)
8,416 reads
SQL Nexus Might Just Save Your Bacon
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it...
2015-03-10
1,671 reads
SQLRally Nordic 2015
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...
2015-03-10
623 reads
A Comprehensive Manual to Manage SQL Server Database
SQL Server is a uniquely designed Relational Database Management System developed by Microsoft. Its basic functionalities include storing, manipulating and...
2015-03-09
728 reads
Solving a slow running query issue with UNION
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...
2015-03-09 (first published: 2015-02-25)
8,812 reads
SQL Saturday Oklahoma City, OK: 422 August 29th, 2015!
We're proud to bring back the OKC SQL Saturday for the 5th year in a row! We have 3 precons...
2015-03-09
758 reads
Transaction Logging in In-Memory OLTP (Hekaton)
In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into...
2015-03-09
1,114 reads
Upcoming Events Where We Can Chat
I get around quite a bit.
Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt,...
2015-03-09
658 reads
Why You Shouldn’t Skip the Infrastructure/Security Architecture Review
It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of...
2015-03-09
265 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