SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,710 reads
All About SQL
Checking Out SQL Vulnerability Assessment
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,591 reads
Azure SQL Database Active Geo Replication Changes
Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...
2017-09-25
525 reads
SQL Server Tracking Suspect Pages
Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...
2017-09-25 (first published: 2017-09-19)
1,594 reads
SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
608 reads
Azure SQL Database Resumable Online Index Rebuild
If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...
2017-09-14
1,355 reads
DBCC CHECKDB Azure SQL Database
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
741 reads
SSMS and MFA support for Azure SQL DB
Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...
2017-08-30
2,221 reads
[Video] SQL Server Deadlocks
SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...
2017-09-08 (first published: 2017-08-24)
1,987 reads
Azure SQL Database – Scaling up
Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...
2017-09-01 (first published: 2017-08-23)
1,303 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers