How to check whether and when sql index statistics were updated last time?
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
7,519 reads
Blog Posts
How to start SQL Server job using TSQL and wait for it to complete?
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
15,754 reads
Overview of SQL Server Backup Types
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this...
2018-04-19
530 reads
SQL server database size, location and volume info
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
580 reads
The Prompt Actions Menu
A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that...
2018-04-19
992 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours....
2018-04-18
24 reads
An Open Letter to PASS and John Q Martin
Dear Mr. Martin and the PASS Organization,
In the spirit of advocating for change in a public way, I’m writing this...
2018-04-18
1,141 reads
Checking Availability Groups with dbachecks
It’s been 45 days since we released dbachecks
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQpic.twitter.com/N8W01KaKo9
— Rob Sewell (@sqldbawithbeard) February...
2018-04-18 (first published: 2018-04-08)
2,235 reads
Dates and Times in SQL Server: the science of time redux
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
2018-04-18
487 reads
Exploring system tables, views, SPs etc
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have...
2018-04-18
1,356 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers