Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-11
3 reads
Blog Posts
Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-11
5 reads
T-SQL Tuesday #121: Gifts Received This Year
Closing out 2019’s T-SQL Tuesday, Mala (blog | twitter) is asking us to reflect on the past twelve months:
This is a time for material gift giving, for many of...
2019-12-11
14 reads
How Serverless is Working in Azure SQL Database
When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...
2019-12-10 (first published: 2019-11-27)
1,051 reads
Install ALL Things SQL Server… What?
Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...
2019-12-10 (first published: 2019-11-26)
908 reads
Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server
ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things...
2019-12-10
504 reads
Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
22 reads
Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
18 reads
The Gift of the SPN
Every once in a while there is an extremely valuable tool that comes along. While the footprint and use frequency of this tool may not be that big, the...
2019-12-10
11 reads
T-SQL Tuesday #121 Gifts received
I am hosting 2019’s last T-SQL Tuesday of the year. I chose to ask people to write on gifts they had received – by way of community, relationships, or...
2019-12-10
11 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