(Stephen Baron) We’ve released a number of great enhancements to further improve the DocumentDB management experience
Tag: sql server
Custom SSMS report to show SQL Server tables per filegroup
(Koen Verbeeck) At a project we have multiple filegroups created in our SQL Server data warehouse. For example, there was a filegroup to store the fact tables on, a filegroup for the dimensions, a filegroup for heavy indexes and so on. This works great at first, but after a while when people come an
SQL Server Buffer Extensions
(Chris Shaw) Have you ever noticed when you are working on a query for SQL Server and the second time you execute the query it runs much faster than the first time you had executed it? There is a reason for this and most likely it is caused by your buffer.
Tracking down CPU spikes using process explorer and DMVs
(Matt Bowler) What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or a page comes in. Next minute you’re pho
T-SQL – Scripting Stored Procedure to Create backup copy on same database
(Prashanth Jayaram) This post is one of the request from OP.
Monitoring Azure SQL Database
(Marcin Policht) One of the primary benefits of Platform-as-a-Service (PaaS) offerings hosted by Microsoft Azure is considerably minimized management overhead. This principle also applies to Azure SQL Database, which eliminates the need to administer and maintain the underlying hardware, operating s
SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR
(Pinal Dave) I have been blogging for almost 8 years now. I believe I have seen pretty much every single kind of email and comments I can receive from users. However, there are sometimes few which just are so interesting that I feel like blogging about it.
SQL Server Disaster Recovery and High Availability Simplified with DH2i
(Jeremy Kadlec) In our SQL Server environment we have a mix of SQL Server and Windows versions not to mention a mix of applications, hardware and server locations (on site, off site, in the cloud, etc.). This makes management, disaster recovery, high availability, etc. very difficult with 24×7 dem
Removing Rows with the DELETE Statement in SQL Server
(Greg Larsen) In my last two articles I discuss using the INSERT and UPDATE statement. These two commands added new rows and modified existing rows. In this article I will explore how to remove rows from a table using the DELETE statement.
Using QUOTENAME() to Protect Against SQLInjection
(Dinesh Asanka) QUOTENAME is function which has been available since SQL Server 2005. This function returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier, such as in the below example
