I tend to stick with the cert sites that Microsoft approves, MeasureUp.com being the best I have used. Their testing engine offers more information on questions about they "why" any...

Through profiler GUI if you are trying to save a trace to file or configure a trace to write to a file, you can save it anywhere you want. I...

The AG would react to however you have the failover mode set for the replica. I would think you want it set to Asynchronous-commit, this would require manual failover.

You can utilize two things: PowerShell and xp_cmdshell[/url] and this will open your world into a new wealth of information to pull or capture for a server. 😀

Now, xp_cmdshell is...

Why do you need to do this using a loop? What have you tried so far?

How can...

I...

Look at configuring logging for the package itself if you are just looking for start and end time of each task. As well if you are using SQL Server 2012...

SSDT is now the BIDS client tool for working with Business Intelligence projects with SQL Server. You can download SSDT from here that includes support for SQL Server 2014 as...

Drop the procedure from your server and go download the SQL Server Backup from Ola Hallengren .

I will touch on the negatives first...

There really are not...

curious_sqldba (7/21/2014)

---

I have come across a question on of the job interviews, i have already answered the question but was curious how other DBA's would answer this.

"With a quick rollout...

smtzac (7/21/2014)

---

Thank you Shawn for your reply. I am bit confuse here, when I run your query I get total no. 97 (when i add all) but when I run...

The query to provide you the number of connections:

SELECT COUNT(*)

,host_name

FROM sys.dm_exec_sessions

WHERE is_user_process = 1

GROUP BY host_name

You can no longer use the rule of session_id greater than 51, because system sessions...

Well, I would want to know why they want it back. That is just to hear him/her give me an answer to see if it is worth me spending that...