Daily Coping 14 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-14
10 reads
Blog Posts
Farewell, Gareth Swanepoel
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
621 reads
Farewell, Gareth Swanepoel
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
2 reads
Query to list all the procedures and triggers not having SET NOCOUNT ON defined
It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and...
2021-01-14
383 reads
SQLSaturday Doesn’t Have to Be a Platform
When we built the first SQLSaturday it was about 2 pages of HTML. No login, no tools, just get it done. Worked ok. Didn’t work so well for the...
2021-01-14
4 reads
T-SQL script to find hierarchy of tables – Row-wise result
As I promised in my previous post T-SQL script to find hierarchy of tables – Columnar result – SQL Server Carpenter, here is another version of the query to...
2021-01-14 (first published: 2021-01-07)
942 reads
Using Amazon FSx for SQL Server Failover Cluster Instances – What You Need to Know!
Intro If you are considering deploying your own Microsoft SQL Server instances in AWS EC2 you have some decisions to make regarding the resiliency of the solution. Sure, AWS...
2021-01-14 (first published: 2021-01-08)
459 reads
Daily Coping 13 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-13
7 reads
EightKB is coming!
The next EightKB is coming on January 27th, kicking off at 2pm UTC. Once again we have 5 mind melting sessions on 5 in-depth SQL Server internals topics, from...
2021-01-13 (first published: 2021-01-07)
509 reads
Power BI: Data Model Optimization
Saving the Day from Delay Part 1 Optimizing your data model can be a daunting task. If you read the intro to this series, you know one of the...
2021-01-13
3 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers