No space queries
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...
2017-04-13
366 reads
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...
2017-04-13
366 reads
Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other...
2017-04-11
475 reads
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,193 reads
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
482 reads
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...
2017-04-03 (first published: 2017-03-16)
1,511 reads
Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...
2017-04-03
488 reads
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
676 reads
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us....
2017-03-27 (first published: 2017-03-14)
1,125 reads
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...
2017-03-27
499 reads
Any object within a database in SQL Server has what is called a four part name. Which rather implies four...
2017-03-20
359 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers