Pulling Security Info
A frequent request I receive is to pull a list of logins/users with certain accesses, role memberships, etc.
I had a...
2016-04-07 (first published: 2016-03-24)
1,459 reads
PASS Board 2016: Update #2
Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...
2016-03-24
433 reads
Partitioning and filegroup restores
I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...
2016-04-05 (first published: 2016-03-24)
1,764 reads
SQLSaturday Belgium: slidedeck
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...
2016-03-24
500 reads
SSC Editorial: On Time, or Not
Is being on time important? I think that might be a revealing interview question. The answer might or might not...
2016-03-24
535 reads
SQLBITS 2016 Agenda has been Published
The agenda for this year’s SQLBITs has been published you can find it here http://sqlbits.com/information/event15/Agenda.aspx?20160507
Our very own David Postlethwaite has...
2016-03-24
391 reads
.Net 4.6.1 and MultiSubnetFailover
Im not a big clustering/HA expert, but I obviously understand the need for such things to exist
However, the standard...
2016-03-24
1,231 reads
The TempDB in SQL Server
Every SQL Server instance has a shared database named TempDB. It is a database where temporary objects are stored and used by other databases. Because it’s only one database...
2016-03-24
24 reads
The TempDB in SQL Server
Every SQL Server instance has a shared database named TempDB. It is a database where temporary objects are stored and used by other databases. Because it’s only one database...
2016-03-24
10 reads
The TempDB in SQL Server
Every SQL Server instance has a shared database named TempDB. It is a database where temporary objects are stored and...
2016-03-24
237 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