A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author for a Microsoft Press...
2019-11-20
47 reads
SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned out. All the content...
2019-11-13
35 reads
With the release of SQL Server 2019, I wanted to highlight in a single place some things that I’m excited about. Drawing on sessions I presented this year at...
2019-11-06
3 reads
Behold! There’s a scary monster called skip-2.0, announced by ESET: This backdoor targets MSSQL Server 11 and 12, allowing the attacker to connect stealthily to any MSSQL account by...
2019-10-30
1 reads
SQL Saturday Oregon — in the city of Portland — is taking place next weekend on Saturday November 2nd, 2019, and I’ll be presenting a revised edition of my...
2019-10-23
4 reads
After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting side-road into deterministic values,...
2019-10-16
28 reads
Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome in the right context!),...
2019-10-09
32 reads
I was thinking about a comment I made to my intern last week. She has been studiously attending to all the different things I do in my day (what...
2019-10-02
18 reads
In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. In the first post we spoke about what...
2019-09-25
14 reads
In my home lab I have an Ubuntu virtual machine that runs both SQL Server 2017 and SQL Server 2019 in Docker containers. After SQL Server 2019 Release Candidate...
2019-09-18
69 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers