(John Miner) Over the next few years, companies will be moving to the cloud for the speed in which services can be deployed, the ability to scale services when demand changes, and potential cost savings from eliminating data centers. Many companies have on premise applications and/or operational da
Tag: sql server
SQL SERVER – Performance Comparison IN vs OR
(Pinal Dave) Some questions never get old and some question and I believe we will be discussing them for many more years in the future. Just other days, I received this question during my SQL Server Performance Tuning Practical Workshop.
Customizing Dashboards in SQL Operations Studio
(Rajendra Gupta) In my previous tips SQL Operations Studio installation and overview and SQL Operations Studio query editor and source control, we explored SQL Operation Studio features. SQL Operation Studio also provides a facility to configure dashboards for monitoring. In this tip, we will explor
Strings vs Identifiers
(Kenneth Fisher) A common mistake, and one I make frequently myself is to use a string in place of an identifier, or vise-versa. So to start, let’s have some definitions, shall we?
Monitoring Azure SQL Database
(James Serra) There are a number of options to monitor Azure SQL Database. In this post I will briefly cover the built-in options and not 3rd-party products that I blogged about a while back (see Azure SQL Database monitoring).
Why Aren’t You Using SSMS 17?
(Grant Fritchey) Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server code. With that, they began an aggressive and exciting series of releases with exciting new functionality in each release. However, you don’t care.
SQL SERVER – Script to Identify Memory Used By Each Database
(Pinal Dave) During the last SQL Server Performance Tuning Practical Workshop, I was asked a very interesting question by an attendee. The question goes like if there is any script available which users can use and figure out if how much memory used by each of the databases.
Summiting that Technical Challenge Part II
(Jason Brimhall) Months ago, I posted an article about some of the challenges encountered while migrating from one service level to another for my blog.
Placing a Mark in SQL Server’s Transaction Log for Fall Back
(Greg Larsen) How many times have you had a programmer come to you and say they accidentally ran an adhoc UPDATE, INSERT, or DELETE statement against their database, and now they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted their DB?
PowerShell cmdlets for managing SQL Vulnerability Assessments
(Ronit Reger) We are pleased to announce the availability of PowerShell cmdlets for managing SQL Vulnerability Assessments for your SQL Servers. The cmdlets can be used to run assessments programmatically, export the results and manage baselines.
