T-SQL Tuesday – Folks Who Have Made a Difference #TSQL2sday
So this month’s T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a...
2017-11-14
300 reads
T-SQL Tuesday #96 – Folks Who Have Made a Difference in my career #TSQL2sday
This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution...
2017-11-14
690 reads
T-SQL Tuesday #96 How did I get started?
Hi Folks,
I’m the new guy that my two colleagues are still trying to convince to write my first blog post...
2017-11-14
446 reads
UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
386 reads
UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...
2017-10-24
181 reads
Connecting to a Remote Instance of SQL Server Using Python
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
864 reads
How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far
I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...
2017-10-05
163 reads
Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
300 reads
SQL Mirroring, Preserving the Log Chain During Database Migrations
This is a reblog of a post that I originally wrote back in January. After using this technique again last...
2017-10-03
122 reads
Concatenation Truncation – Are your strings being truncated?
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,197 reads
Blogs
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Forums
Looking for a Recommended Azure SQL Managed Instance Book
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
timeout in vs for ssas tabular deploy is 0 but i still timeout deploying
hi we run 2019 std but i'm testing this on 2016. following some old...
Table variable declared within cursor persists across loop iterations
If you run this code it creates a 2 row cursor loop. Within the...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers