Have you seen this type of an informational message in your SQL errorlog before? If so, then I hope the...
2013-01-07
1,096 reads
In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files...
2012-12-31
22,863 reads
Last week, I attended my very first SQL Saturday event in Washington, DC. Although I don't live anywhere near Washington,...
2012-12-18
544 reads
You may have noticed in my code examples, I always include a semicolon ";" at the end of my TSQL statements. ...
2012-12-11
1,003 reads
I think most DBAs know that you can use the Windows Performance Monitor to capture performance metrics for your SQL...
2012-12-04
885 reads
Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...
2012-11-21
3,756 reads
UPDATED -- Dec 31, 2012 -- Be sure to read Part 2 of this post discussing xp_dirtree.
Last week I blogged about how...
2012-11-13
62,273 reads
If you're a DBA like me then you're probably pretty detail-oriented and like to keep things very organized. For example,...
2012-11-06
725 reads
Management Studio is great tool with almost everything you need right at your fingertips. Notice I said "almost". I like...
2012-10-30
2,037 reads
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,512 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers