(Manoj Pandey) This time SQL Server 2016 has made good additions in area of Security by introducing features like:
Tag: sql server
Basic SQL Server Performance Troubleshooting For Developers
(Tony Davis) The speed of a slow SQL Query can almost always be improved. In SQL Server, the query optimizer determines the best way of executing the query, based on the evidence it has. The same query can be executed in many different ways as the data size increases, new indexes become available, o
Performance Tuning – Steps to make sure that you are comparing apples to apples
(Devi Prasad) While working on optimizing performance of SQL Queries, its very important that the right numbers are compared.
SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal
(Pinal Dave) There are parts of SQL Server where I always like to take expert advice. Sometimes a quick call to a friend can save you tons of time. When I see topics around AlwaysOn, though I know what the basic steps are to building and working with AlwaysOn, the hardcore troubleshooting is not the
Obfuscate column level data by using “Dynamic Data Masking” in SQL Server 2016
(Manoj Pandey) This time SQL Server 2016 has made good additions in area of Security by introducing features like:
Basic SQL Server Performance Troubleshooting For Developers
(Tony Davis) The speed of a slow SQL Query can almost always be improved. In SQL Server, the query optimizer determines the best way of executing the query, based on the evidence it has. The same query can be executed in many different ways as the data size increases, new indexes become available, o
Performance Tuning – Steps to make sure that you are comparing apples to apples
(Devi Prasad) While working on optimizing performance of SQL Queries, its very important that the right numbers are compared.
SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal
(Pinal Dave) There are parts of SQL Server where I always like to take expert advice. Sometimes a quick call to a friend can save you tons of time. When I see topics around AlwaysOn, though I know what the basic steps are to building and working with AlwaysOn, the hardcore troubleshooting is not the
Export Table to CSV File – step by step
(Derek Dieter) A very common requirement with SQL Server is to export a table to a csv file. It’s actually an easy task when using SQL Server Management Studio (SSMS).
Discovering SSRS Report Parameters using PowerShell
(Donabel Santos) We can use PowerShell to discover many SSRS properties, including the different parameters available in a report. This blog post is based on SQL Server 2014 and PowerShell V5.