Essential Guide to DB Monitoring
Learn how you to automate, track, report and troubleshoot database performance problems and causes with “The Essential Guide to Database Monitoring.” Get advice on how to make gathering performance metrics and assessing database health less …
My MVA course about SQL Server on Azure – PaaS or Iaas?
If you are tired today maybe you could take your time and spend the whole weekend with the SQL Server 2014 and Azure? The new MVA course is ready 🙂 and waiting for you. Just visit the link http://bit.ly/1CXZT90 and enjoy. Watch out – it’s in …
More Useful MVA Training Options
I find many of the MVA courses great for quickly getting across concepts or areas that I haven’t worked with before. This month, the local MVP program has asked me to highlight the following MVA courses. The first two in particular look useful fo …
Identifying Transaction Log Backup Gaps
Transaction log backups are critical for point-in-time recovery. If you’re in full recovery mode you also better be sure to be backing up those transaction logs because it’s the only way to keep your log files healthy and lean. read more
Microsoft SQL Server on XtremIO- Meeting SQL DBA challenges
Sponsored by: EMC Hear from EMC experts how to empower your SQL Server read more
Data Mining Algorithms – K-Means Clustering
Hierarchical clustering could be very useful because it is easy to see the optimal number of clusters in a dendrogram and because the dendrogram visualizes the clusters and the process of building of that clusters. However, hierarchical methods don …
Being a Good #SQLHelp(er)
If you are active on Twitter, you may have found your way to the SQLHelp hash tag and seen the high level of interaction. SQLHelp has become a popular method of getting quick answers to SQL questions. read more
For future Analysis Services development, will you use:
Multidimensional Tabular Both
Looking for SQL Server 2014 SP 1… Hold Off a Bit Longer
Microsoft released service pack 1 for SQL Server 2014 on April 15, 2015. Why can’t we download it though? read more
When is a Hyper-V Virtual Machine Not Really a Virtual Machine?
Former Sysadmins When you set up a Windows Server, you might be tempted to add a bunch of roles, just in case you want to use them in the future. Don’t do it: things can get weird. If you add the Hyper-V role to Windows Server 2012 and higher, it …
Who Will Be Attending HostingCon 2015?
Who will be attending HostingCon 2015? Content Classification: Marketing read more
SQL Server 2014 Service Pack 1 was available – but there’s a catch!
Stop me if you’ve heard this one before . Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB) . From the Release Services team blog : Notice: The SQL SSIS team has found an issue wi …
Dynamic Management Views in Azure SQL Database v12
When the Dynamic Management Views (DMV) were introduced back in SQL Server 2005, we got our hands on some absolutely wonderful tools that allowed us to observe much of the inner workings of SQL Server using the language we use most, T-SQL. Prior to the …
How to Collect and Investigate Performance Data to Solve SQL Server Workload Crimes with Foglight SQL
Sponsored by: Dell Wednesday, June 17th, 2015 @ 2pm ET – How to Collect and Investigate Performance Data to Solve SQL Server Workload Crimes with Foglight SQL webinar read more
How to Collect and Investigate Performance Data to Solve SQL Server Workload Crimes with Foglight SQL PI
Sponsored by: Dell Wednesday, June 17th, 2015 @ 2pm ET – How to Collect and Investigate Performance Data to Solve SQL Server Workload Crimes with Foglight SQL PI webinar read more