Webinar Q&A: SSRS Subscriptions and Data Alerts
Updated 10-16-2014 at 11:20 AM Eastern
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the...
2014-10-15
1,518 reads
Blog Posts
#TSQL2sday #59 – My Heroes
Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....
2014-10-14
542 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-
Mirroring stateDescriptionSYNCHRONIZINGThe contents of the mirror database are...
2014-10-14
1,989 reads
Database Mirroring States (SQL Server)
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of...
2014-10-14
6 reads
Murder In Utah
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-10-14
584 reads
Murder In Utah
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-10-14
2 reads
Some Thoughts On Running a Chapter
Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader,...
2014-10-14
868 reads
SQL Server Checksum
Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...
2014-10-14
2,363 reads
The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,944 reads
T-SQL – Scripting Stored Procedure to Create backup copy on same database
This post is one of the request from OP.
Download SQL Backup SP in the same database
The probelm statement 1:-
Create a...
2014-10-14
894 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