SQL Server – Import text file using xp_cmdshell
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK...
2013-07-29
1,062 reads
SQL Server Management Studio Rainbow Edition
Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management...
2013-07-29
696 reads
What I’m sayin’ is…everything is fine.
Let’s say you are a member of the development team. Your team got a new project in the works, so...
2013-07-29
637 reads
Free Ebooks! Free Ebooks!
There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot...
2013-07-29
702 reads
Encourage Someone You Respect To Run For The PASS Board of Directors
PASS is accepting candidate applications for the 2013 election through August 7th, 2013. Later this year we – the PASS membership...
2013-07-29
636 reads
SQL Saturday #252, Christchurch New Zealand
TweetSQL Saturday #252 Christchurch, New Zealand
G’day,
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of...
2013-07-28
1,175 reads
SQL Saturday Sacramento was terrific
This year’s SQL Saturday #222 in Sacramento was a blast. This event was certainly the high point of my summer,...
2013-07-28
783 reads
Security Questions: Recommended Security Book
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-27
719 reads
Go ahead. Laugh.
I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one...
2013-07-27
536 reads
Hardware 201: Selecting and Sizing Database Hardware
On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download...
2013-07-26
1,112 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers