How to configure SSIS in SQL Server AlwaysOn

March 30, 2016 Andy 0

Question I have AlwaysOn Availability Group setup for my SQL Server. Now I would like to configure SSIS. How do I do it? Below link provides some information but since I am not DBA it’s difficult to understand this article: AlwaysOn Availability Groups and SQL … [Read More]

Why is the MSDB database TRUSTWORTHY?

March 24, 2016 Andy 0

Question The TRUSTWORTHY setting can be rather dangerous if you aren’t careful and except for specific circumstances the recommendation is to keep it turned off. However by default the MSDB database has TRUSTWORHTY set ON by default. I’m curious why? I’ve read this entry in … [Read More]

Shortcuts Cheat Sheet – SSMS & Windows

March 7, 2016 Andy 23

Edit: I’ve published an updated version of my cheat sheet. Find the latest version by in the sidebar –> I’ve presented my Shortcuts from an Impatient DBA talk a few times now, and I really love it. Everyone learns something, whether you’re a Junior Developer, or a multi-decade … [Read More]

No Picture

Decoding sql_handle

February 29, 2016 Andy 0

If you’ve ever looked at sys.sysprocesses or sys.dm_exec_requests (or a number of other DMVs), you’ve noticed there is a column called “sql_handle” that contains some binary gobbledygook. Books Online gives the (un)helpful definition as “Hash map of the SQL text of the request.” sp_WhoIsActive In … [Read More]

Data Compression: How page compression works

February 22, 2016 Andy 1

SQL Server supports two kinds of data compression on rowstore data. Columnstore compression is for a different day. You can compress heaps, clustered indexes (on both tables and views), and nonclustered indexes (on both tables and views). Compression requirements Data compression is available in SQL … [Read More]

No Picture

xp_sqlagent_enum_jobs alternative

February 18, 2016 Andy 3

What’s xp_sqlagent_enum_jobs? If you landed on this post, I’m guessing you know the answer to this, so I’ll be quick. xp_sqlagent_enum_jobs is an undocumented (and thus, unsupported) extended procedure that gives information on whether a job is currently running, when it last ran, when it runs … [Read More]