(Jack Vamvas) Question: I’d like to understand the limitations of xp_logininfo. I use xp_logininfo for quick reference to SQl Server security troubleshooting .

(Manoj Pandey) Today I was trying to connect to a SQL Server instance of my DEV machine from SSMS, it took bit more time than usual and threw me an error:

(Pinal Dave) Just the other day I got an email with user asking how does the @@idle function work with SQL Server as when he runs them it gives him some number but the number is not easy to interpret. I totally agree with the observation.

(Nakul Vachhrajani) As we have been discussing over the last couple of weeks, moving data from a “source” to a “destination” is the crux of SSIS. The data source can be literally anything – a SQL Server database, a web-service, a script, an XML or even a conventional delimited file.

(Kenneth Fisher) Years ago I worked for a company that had a rather cool way of handling requests. When we ran the request the query we used and the output were saved to a directory on the network.

(Atul Gaikwad) We have a few reporting servers where we have SQL Server Log Shipping setup and we are responsible for making sure the data is in sync for reporting users to generate reports.

(Kevin Conan) I was recently asked if after you setup a Temporal Table, can you modify the schema? It was a great question because if you cannot change the schema, then you would have to drop and recreate the table every time you need to change the schema which means you would potentially lose all

(Pinal Dave) Received an email “Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our sysmail_mailitems table. We are also facing performance issues.” I have been an independent consultant for a while and one of the services I provide is “On Demand (50 mi

(Glenn Berry) On November 16, 2016, Microsoft announced some very significant changes for SQL Server 2016 Standard Edition, which were implemented in SQL Server 2016 Service Pack 1 (Build 13.0.4001.0). Many very useful programmability-related features that were previously only available in Enterpris

(Vadivel) Met a DBA from a company who are in business for ~2 years. During the conversation came to know they have never tested their backup file – not even once. Also, they have very rarely used DBCC CheckDB command. Should I call it as surprised or shocked?