Steve Jones - SSC Editor (11/17/2014)

---

Gary Varga (11/16/2014)

---

Could we be looking at this from the wrong way round? Should our languages and components not put security first? Should it be...

I also use Ola's solution as the basis for backups, though with a few slight tweaks for a vendor app environment. I also very much support no more than...

As always, the #1 problem is human beings. Most other problems can be traced to this, and the bulk of them are combinations of corporate culture, explicit vs. implicit...

I copy and pasted into a text editor, verified that 1 and 4 were the same, guessed 1 was more likely to get the point, and lost with a correct...

First, a technical option:

What happens if you put a firewall in between set to Reject all access to the internet, so at least there's a very fast response to any...

Starwatcher (10/30/2014)

---

kenambrose (10/30/2014)

---

very simple solution to all the nonsense.

MAKE ALL COLUMNS NOT NULLABLE.

If you can't figure out how to design a schema where that works for your business requirements,...

sqldriver (10/15/2014)

---

One thing you could do is hash the sp text and compare the last date modified. So if the modified date is newer and the hashes don't match, then...

No; I just run a redeploy anytime I question whether an SP is up to date.

The only other real way to do it is simply compare the entire definition column...

Start by putting a standardized, unique comment at the start of each stored procedure, listing the version.

Then you can use something like:

SELECT

CASE

WHEN PATINDEX('%UniqueVersion:%',definition) > 0 THEN SUBSTRING(definition,...

Ok, my post just got eaten, and I'm out of time, so here's the short short short version:

First, is_policy_checked is meaningless except during the actual password change operation:

select name, is_policy_checked,...

Is SQL Server (the core product) mature?

Well, it has some of the hallmarks of a mature product - very limited feature growth (bad point: very limited bug fixing of even...

This is the most important piece of advice in...

Personally, I'd recommend doing this from a DOS prompt/Windows scheduled task/Enterprise scheduler scheduled task from the get-go; the business requirement will only get bigger from here!!! The next thing...

Very interesting, though I'd find a version that looks for not only internal objects, but also explicit objects like #temp and ##global temp tables, and even "real" tables in tempdb,...

Thank you for the script, Carolyn; both sets of SQL Statements (the alerts and the notifications) work well on SQL 2012, both on error number and severity level based alerts.

One...