SQL Server vNext
SQL Server vNext
I have been pretty busy recently working with Joe Sack from Microsoft and getting my hands dirty with SQL Server vNext accessing some cool stuff (which obviously I can’t talk about – under NDA) and b...
SQL SERVER – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down
SQL SERVER – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down
Have you ever been in a situation where SQL Server shuts down by itself? It sounds strange but I met across a gentleman in flight who reported this issue to me. Since I was curious to know the cause, ...
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
I have started blogging on my site long ago and my whole idea was to make script repository so that others can reuse it. Now when I look back, there are many scripts and many solutions which I have w...
IT Pros Roundup: Windows as a Service
IT Pros Roundup: Windows as a Service
Not sure what Windows as a service is? With Windows 10, Microsoft moved to deliver Windows as a service which introduces a new way for how it’s built, deployed and serviced. Start by viewing this 5-m...
Microsoft Vendor process – some issues and how I resolved them
Microsoft Vendor process – some issues and how I resolved them
As you will know, I have been working extremely hard on the UK Power BI Summit. One thing to note: If you are thinking of setting up a community event, I would recommend that you engage with Microso...
Foglight for SQL Server: Business Intelligence Monitoring – SQL Server Integration Services
Microsoft has evolved their marketing over the past several years to focus on the fact that SQL Server is more than just a Relational Database Management System (RDBMS). You may have noticed, that Mi...
My backup and SLEEP_BPOOL_FLUSH
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more specifically Physical disk:Avg sec/read(orange/yellow line) and Physical disk:Avg sec/write(blue...
Foglight – Supersized Deployment Use Case
This large organization was using 6 different monitoring products. SCOM for windows, BMC for Linux, Riverbed Steel Central for APM, Oracle OEM for Oracle Databases, SCOM for SQL Server databases, VM...
Foglight Tip: Silence Alarms Using Blackouts
During periods of scheduled maintenance, you may wish to prevent Foglight from sending alarms about the systems involved in the maintenance task. The use case is quite obvious. You know the system's d...
What is new in Spotlight on SQL Server Enterprise version 11.6?
What is new in Spotlight on SQL Server Enterprise version 11.6?
Spotlight on SQL Server Enterprise 11.6 is here! So what’s new? Spotlight introduces Federation architecture A Spotlight Client can now monitor connections from multiple Spotlight Diagnostic Servers i...
Test Running a Tuned SQL is Not An Easy Job
Test Running a Tuned SQL is Not An Easy Job
In SQL Optimizer for SQL Server, we have built a very sophisticated test run facility for users to find the best SQL alternative from all generated SQL alternatives to solve the user’s specific proble...
Integrating Spotlight on SQL Server Enterprise with Your Enterprise Monitoring Tool
Integrating Spotlight on SQL Server Enterprise with Your Enterprise Monitoring Tool
I very frequently come across DBA's that that are either overwhelmed with the complexity of their organizations enterprise monitoring platform, or underwhelmed with its out of the box monitoring and d...