PASS SQL Saturday Events : October 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note...
2013-10-02
339 reads
Blog Posts
PASS Virtual Chapter Events : October 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-10-02
806 reads
PASS Virtual Chapter Events : October 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-10-02
412 reads
Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the...
2013-10-02
1,296 reads
Setting Up a Domain Controller with PowerShell
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk...
2013-10-02
2,036 reads
SharePoint Reporting Services Content Types Missing
Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the...
2013-10-02
2,821 reads
Social Engineering: How to prevent unauthorized access to SQL Server using SQL Logins
People are always concerned about Security when it comes to their data. I don’t blame them, I love keeping my...
2013-10-02
729 reads
SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,487 reads
Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,325 reads
Why I am not an MVP
On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to...
2013-10-02
765 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers