Let's say you already have a project folder called \MyDatabase, which is working folder for SVN. Using your tool, script your database out to another project folder called \MyDatabase2, and...

Regardless of how or where the T-SQL is stored at rest, it must be decrypted before SQL Server can compile and execute it. Any user with SYSADMIN privillage can use...

There is strong demand in the market for people with solid database development and administration skills. However, the IT industry is also plagued by a legacy of poorly written SQL....

Assuming you could load GB of disk storage, GB of RAM, Windows, and SQL Server, a Raspberry PI would be severely under powered for even single user testing purposes. If...

I'm not convinced that guessing or brute forcing passwords is the method most hackers use to break into accounts. One problem is that folks re-use the same password across multiple...

kiwood (2/23/2016)

---

I think the government needs to do the right thing and get involved in the hospital's operations for awhile. It should start with a fine for not having things...

[.. Sealand was on shaky legal ground and had no allies; it's likely all that stopped it from being attacked was its proximity to the UK. More importantly, the advantages...

It's funny how Ashley Madison is becomming the defacto sample database for MySQL. :crazy:

etl2016 (2/21/2016)

---

Hi,

I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.

Could you please suggest if 8GB RAM and Core...

When young children are deep into some game or puzzle, they somehow make time slow down, stretching a single rainy afternoon into an eternity. As adults we somehow lose that...

Practically everyone who has been in the industry for more than a handful of years has found themselves in this position at some point. However, it's important not to get...

Should Production Databases Be in a VCS?

Yes, database administrators should periodically script out the schema for each database and keep it versioned separately under VCS for point in time comparisons,...

Alan.B (2/17/2016)

---

+1

There's so much good...

Gary Varga (2/18/2016)

---

Eric M Russell (2/17/2016)

---

Gary Varga (2/16/2016)

---

Eric M Russell (2/16/2016)

---

...attempting to use the developer's code repository as a basis for a schema comparison to production is logistically difficult, if...

The DMV sys.dm_exec_query_stats returns returns an assortment of aggregated measurements for each cached execution plan. The column sql_handle is a unique hash key.

https://msdn.microsoft.com/en-us/library/ms189741(v=sql.110).aspx

It can be joined with sys.dm_exec_sql_text on sql_handle...