Category Archives: Beginner

PowerShell for the Easily Frustrated N00b, or, “A Simple and Useful Command”

The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro).  Yes, I made sure to add the network location that holds my files, and yes, I rebuilt the file index. The damn … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Beginner, NonSQL, Powershell, Random helpfulness, sqlserverpedia-syndication, SSC | 3 Comments

Applied SQL: Server Side Traces

It’s time to get your server side trace on, with a little practical application! I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, basic experience with SQL … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL | Tagged | 3 Comments

Applied SQL: sys.sql_modules

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL (including JOINs and LIKE), basic knowledge of catalog views Reading: SQL Server Books Online sys.sql_modules article. Level 1 … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL | Tagged | 15 Comments