When was SQL Server last restarted?
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,177 reads
SQLSaturday #41 - Atlanta Session Recap
Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...
2010-04-29
1,447 reads
PASS Update #29
By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS...
2010-04-29
1,460 reads
A DMV a Day – Day 29
The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...
2010-04-29
2,915 reads
A Identity Bug
Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
drop table aa
create table...
2010-04-29
2,225 reads
How to Tell When SQL Server Started?
As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...
2010-04-28
1,854 reads
SQL Server Connection Strings
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,584 reads
Undocumented Capabilities of Extended Event Objects
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,175 reads
SQL University Post Coming Tomorrow
This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...
2010-04-28
1,447 reads
Social Networking and SQLSaturday
I think we do a pretty good job of delivering technical content, but not such a great job at getting...
2010-04-28
1,467 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers