I can take this one.

You deleted records from the numbers table, but your filter is being applied to the phone table. How many records are in the phone table in your first test (query...

Brandie Tarvin (4/16/2014)

---

Another question. Once I finish writing up the Powershell script, how do I make it part of the SSIS package or the SQL Server Agent job?

Is it as...

Brandie Tarvin (4/16/2014)

---

GAH.

Is this Powershell error normal?

It gives me a link for execution...

If you can do it in C# it should be possible, and more likely easier to write, in PowerShell.

Brandie Tarvin (4/16/2014)

---

The part I keep getting hung up on is the "automated program" part of the document. What program should I be using and is there a way for...

So the HTTPS access they are providing is just a form entry?

File system task is used to manipulate files similar to how you might with Windows Explorer. In this instance that is not going to help you move the file to...

You can go through this video on finding query timeouts from MidnightDBAs.

You basically use Profiler or server-side trace to track the T-SQL starting and ending events. The statements that have...

For those interested a few blog post are slowly coming out on the licensing changes with SQL Server 2014. This blog post[/url] has the link to the licensing page for...

So just to clarify, who is the taker? 😀

There is no option in T-SQL no, but SQL Server can be used to accomplish this if you want.

I would simply use Scheduled Tasks to execute the PowerShell script, but...

Step-by-step, I don't have that much time at the moment.

You can piece this together yourself with a little work. For Powershell search for the commandlet "Get-EventLog", there are parameters to...

(1) If I need to constantly check and be notified immediatly I would set...

Your backup chain goes by information (the LSNs) that is within each header of the physical backup file (full, differential, or log).

The information on the database/log backups written to the...