Why not NOLOCK?
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...
2015-03-18
1,269 reads
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
559 reads
Excel Tip #21: Hiding Scrollbars in Excel Services Web Part
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-03-17
816 reads
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
941 reads
Combating the CXPacket Wait Type
Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...
2015-03-24 (first published: 2015-03-17)
7,477 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
366 reads
The Demo Setup–Attaching Databases with Powershell
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,584 reads
“Thing IS NOT NULL” isn’t the same as “Thing != NULL”
I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)...
2015-03-16
584 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-16
645 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-23 (first published: 2015-03-16)
7,924 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
BCA KCP Gresik Kota Baru Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Kalimantan No.76 Kavling, Blok RV 55B, Wonorejo, Yosowilangun, Kec. Manyar, Kabupaten Gresik,...
Alamat Telp BCA KCU TUBAN Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers