I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-06-14 (first published: 2019-05-30)
330 reads
I recent chatted with some folks who have a permissions problem in SQL Server. The permissions problem isn’t technical — it’s a process problem. The issue is that these...
2019-05-30
22 reads
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are ... Continue reading
2019-05-30
71 reads
Both my wife and I will be speaking this weekend at SQLSaturday Dallas, back-to-back in room 1.102, and both on topics perfect for entry level IT pros, job seekers,...
2019-05-30
23 reads
Back in 2012 at SQLSaturday Pensacola, I did a lunch-time lightning talk on indexing, which was supposed to have a big finale on how FK's could silently help with...
2019-05-29
19 reads
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-05-28
44 reads
Late last year, I wrote a series of articles about Predictive Modeling using R and SQL Server Machine Learning Services. At the time, I thought MLS was an underutilized...
2019-06-17 (first published: 2019-05-28)
729 reads
One of the most challenging aspects of being a good leader is building a team that can support the initiatives you will set forth. Without a team that will...
2019-06-14 (first published: 2019-05-28)
464 reads
In my last post I showed how you can create a volume with your container. I then showed a few things you can with a container using a volume....
2019-06-17 (first published: 2019-05-28)
245 reads
A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading
2019-06-13 (first published: 2019-05-28)
828 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers