What’s Next for SQL Clone?
I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s...
2017-04-05
650 reads
How do I change the increment of an identity column?
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
495 reads
Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
437 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
178 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
476 reads
Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
660 reads
ADO Connection Resiliency
It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection...
2017-04-05
678 reads
DevOps at VSLive–Austin
You can see me in May at VS Live in Austin, where I and many others will be talking DevOps....
2017-04-04
533 reads
IT Security Audit & Compliance Webinar Today (April 4) at 1 PM EDT
I’m speaking as part of a small panel for IT GRC Forum on keeping up your data security program in the...
2017-04-04
314 reads
I’m going to make you love backups
On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and...
2017-04-04
357 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers