Checking Time Zones in SQL Server
I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...
2017-01-13
1,337 reads
SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)
Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...
2017-01-12
1,351 reads
Vote for @SQLBits Sessions (pick me, pick me)
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...
2017-01-12
464 reads
Why won’t my SQL Logins work?
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...
2017-01-12
814 reads
Using the PowerShell SQL Provider with SQL Authentication
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...
2017-01-12
2,066 reads
Tables can't be compared
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...
2017-01-11
31 reads
Tables can't be compared
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
211 reads
More #SQLintheCity–Behind the Scenes
I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live...
2017-01-11
550 reads
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
43 reads
Killing databases in SQL Server on Linux
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on...
2017-01-11
1,015 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers