(John Grover) I need to get alerts from my SQL Server databases 24/7, but I don’t always carry my laptop to check email and when I do, I may not be near an internet connection. I always have my cell phone with me, though. Can I get my SQL Servers to send me a text message when there is an […]

(Ravikanth) There was a question on StackOverflow about adding local users to SQL Server logins. I provided an answer to that and realized from a user’s comment that the SMO method to create a SQL login works only in a specified manner.

(Sandesh Segu) As part of the DBA job, it is very important to monitor the SQL Server and its related service and ensure that the services are always up and running.

(Michael Otey) One of the most difficult-to-understand options in SQL Server 2012 is the ability to encrypt data. This is mainly because of all of the different encryption capabilities offered.

I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve Wynkoop and I talk a lot about designing and managing our professional careers on a weekly interview on SSWUG.org. This episode was about how to give and get feedbac

(Steve Stedman) DBCC HELP is used get more information about a specific DBCC Command.

(Hemantgiri Goswami) Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting information is bit tedious when you have hundreds of server in your environment.

(Dallas Snider) I am new to SSIS and need to know how to read a comma-separated value (CSV) file into an SQL Server Integration Services (SSIS) 2012 package? What are the steps that you need to follow?

(Nagaraj Venkatesan) I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog using the script compared to using SSMS. xp_readerrorlog gives more options to filter the log for specific dates or containing specific string etc

(Thomas LaRock) One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries despite there currently being an upper bound due to things like network bandwidth, the spe