Schedule Announced for SQLSaturday #151 in Orlando
We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...
2012-08-13
353 reads
Audit Yourself Regularly
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,717 reads
Bloggers–Don’t Make It Hard to Comment
Lately I’ve hit a couple blogs that wanted me to enter some kind of credentials before I could post a...
2012-08-13
381 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,765 reads
Find AD user detail - PowerShell Script
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,926 reads
Find Members of AD Group - PowerShell Script
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,167 reads
Monitor Deadlock in SQL 2012
Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...
2012-08-16 (first published: 2012-08-12)
18,095 reads
How to list all CLR objects inside your database?
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,322 reads
How to find SQL Agent Jobs without Notification Operator Configured?
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,675 reads
Ever Want to See How a Hand Plane Works?
If you’re interested in woodworking, read on!
I’ve been thinking of making a hand plane out of wood and was doing...
2012-08-12
819 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers