Free Month To PluralSight!
Free Month of PluralSight!
Ok, personally this is pretty cool. www.SQLSkills.com is giving away a free month to pluralsight! Well, let...
2014-02-25
1,275 reads
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
1,189 reads
Lock Escalations
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-03-03 (first published: 2014-02-25)
4,759 reads
Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias
Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!
Let's welcome them to NYC! Now at...
2014-02-25
1,215 reads
Notes From SQLSaturday #273
Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not...
2014-02-24
677 reads
PowerShell – Export SQL Data to Excel with Powershell
SQL Server Export to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some...
2014-02-28 (first published: 2014-02-24)
5,060 reads
SQL Server sample databases
Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have...
2014-02-24
228 reads
The “Perfectly Optimized” Page – #infographics
The “Perfectly Optimized” Page infographic states that there is no such thing as a “Perfect Page”. But don’t be discouraged!...
2014-02-24
919 reads
31 Days of SSIS for SQL Server 2014 Update Question
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS....
2014-02-24
1,304 reads
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
832 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers