Join me for a free SQL Performance webcast on July 14th!
With less than we week away, I can say that I’m really excited to reach more people in the community...
2016-07-08
386 reads
Confessions of a Microsoft Addict
New SQL Server community tool
For those of us in the US, it’s our day of independence. A day that stands for FREEDOM and happiness....
2016-07-05
1,599 reads
Does my database have data type drift?
Over the years I have come to see that every database has what I call data type drift. Simply put,...
2016-07-13 (first published: 2016-06-28)
2,494 reads
Are my SQL logins weak?
Security is a vital component of data security. In today’s day and age it is imperative to think about security....
2016-07-04 (first published: 2016-06-24)
1,608 reads
Is Resource Monitor (resmon) all I need to troubleshoot storage?
I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower...
2016-06-30 (first published: 2016-06-23)
1,599 reads
Microsoft finally got SQL setup right!
This past week, Microsoft revealed that SQL Server 2016 will be available in June. Exciting news indeed! With that said,...
2016-06-22
461 reads
SQL Server Security Series, part 1
In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server...
2016-06-22
473 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers