Urg! One word to describe an interesting surprise I ran into today. On the Production server the tool created an extended stored procedure that started
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
Get listing of Databases user has access to …
You can right click on each user to find out what database he or she has access to; which can be very time consuming. I
Surface Area Configuration Manager *R.I.P.*
All who liked the SACM raise your hands … Right that’s what I thought no one heh; okay it wasn’t that bad. But non the
"New Maintenance Plan…" doesn’t work
For some reason Microsoft decided not to enable that function in some editions of RTM in SQL server 2008 (annoying but meh). So looking around
01 – SQL Server Related On-Line References
Over the past month or two I been saving any link I find interesting for SQL Server sometimes other topics. To build a library and
Default Backup Path in SQL 2008
In the SQL Server 2008 setup you can now set the default backup location but in case you set it wrong or need to change
SQL Canada (SQLCAN) 