In this post, we discuss about the context within which SQL Server accesses network resources via the Database Engine and SQL Agent. How Does SQL Server Access Network Resources When you run adhoc queries (i.e. execute stored procedures, use OPENROWSET, etc.) targeting resources outside the scope of the SQL Server instance (i.e. a file … Read more…
[Update: SQLArtBits is Now SQLNetHub!] You can find the latest version of DBA Security Advisor here. On April 5 2017, SQLArtBits releases DBA Security Advisor v2.0. This article gives a sneak peek of the upcoming new release of DBA Security Advisor v2.0. DBA Security Advisor is a powerful tool developed by SQLArtBits that allows Database Administrators (DBAs) … Read more…
Today is big day. Today, DBA Security Advisor is finally released! It has been a long journey. Two years of research, development, testing, QA, and the list goes on! I work with SQL Server for more than 11 years and I have seen hundreds of SQL Server installations and setups. I have seen best practices … Read more…
[Update: SQLArtBits is Now SQLNetHub] You can find the latest version of DBA Security Advisor here. After almost two years of heavy development and extensive testing, in three days, on June 28 2016, I will be releasing my brand new software tool for SQL Server. The name of the tool is ‘DBA Security Advisor‘ and as … Read more…