PostgreSQL vs. SQL Server Notes
This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…
Read MoreCategory: Tools
SQL documentation tools and permissions required
Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:
|
1 2 3 4 |
USE myDatabase GO GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup] |
Views – 1040
Read More
My Microsoft Code Extensions
Here are the current set of MS Code extensions I use on a daily basis. Views – 1684
Read More
Devart Studio for SQL Server Issues
I am documenting known issues I have run into with Devarts’ Studio for SQL Server here. I want to state up front that…
Read More
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read More
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read More
Using SQL Server 2012 Performance Dashboard Reports
Below is the link to install (on your local workstation instance of SSMS) the SQL Server 2012 Performance Dashboard Custom Reports. SQL Server…
Read More
Using SQL Profiler to trace a sproc
Using SQL Profiler to trace a Stored Procedure call Views – 1351
Read More