Vote Now to Pick the GroupBy Conference Lineup
Voting closes soon at GroupBy, the new free online conference where YOU pick the lineup. Here’s the sessions up for votes – there’s a lot of them, so maybe focus on rating the sessions you find the most interesting – quantity of …
Some Tips for Minimising the Pain of HTML Input Forms
HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible to reduce the drudgery of form-filling to the minimum and minimise mistakes. Dino explains four …
Troubleshooting a painful query using execution plans in SQL Monitor
When something’s wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem fast. Grant Fritchey explains how you can use execution plans inside SQL Monitor to help quickl …
SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate
After seeing various issues with SQL Server startup problem, I felt that I know almost most of the errors, but I was wrong till someone contacted me with a new error. But I learned that Errorlog is always a good place to start with. SQL SERVER …
Should I Install Multiple Instances of SQL Server?
Marina Towers in Chicago Instance stacking is the technique of installing multiple instances of SQL Server on the same Windows instance. For example, you might have a VM or server named SQLPROD1, and have: SQLPROD1 – default instance of SQL Serve …
Downloading multiple files from internet with SSIS and C#
This is a tutorial to download multiple files from internet using the SSIS Script Task. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root c …
Can comments hamper stored procedure performance?
After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.
SQL SERVER Management Studio – Taking DB Offline Made Easier
I have an appetite to observe and learn from what happens around me more. These are the best ways we realize how life has been gifted to us. Since I have been traveling lately like mad with families where there has been enough vacation filled with some …
SQL Server Management Studio (SSMS) v16.5.1 Now Available
An updated version of SQL Server Management Studio (SSMS) for SQL Server 2016 (v16.5.1) is now available . :{>…(read more)
SQL Server Diagnostic Information Queries for December 2016
This month, I have added a separate set of queries for SQL Server vNext. Right now, they are almost identical to the SQL Server 2016 queries, but I will make changes to surface new functionality in SQL Server vNext over time. I have also added support …
Availability Groups: More Planned Downtime for Less Unplanned Downtime
I often hear companies say, “We can never ever go down, so we’d like to implement Always On Availability Groups.” Let’s say on January 1, 2016, you rolled out a new Availability Group on SQL Server 2014. It’s the most …
Cloning a SQL Server Login with all permissions using PowerShell
Cloning a SQL Server login with permissions that match another login is a common task. In this post, Jeffrey Yao shows how this an be done using PowerShell.
Stairway to Exploring Database Metadata Level 5: Exploring Facts About Tables
Now that we’ve explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.
SQLBits 2017
SQLBits 2017 has been announced. The conference will take place on April 5-8, 2017 in Telford, UK.
SQL SERVER – FIX – Error: 26023 – TCP Port is Already in Use
One of my clients approach me that after patching of SQL instances, database mirroring stopped working. As usual, I asked them to share ERRORLOG file SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location. In this blog …