Data Governance is a lot simpler when databases and IT teams are not operating in silos. It helps if there is one application for each line of business, one set...

SQLmansell (10/12/2015)

---

Eric M Russell (10/12/2015)

---

Temporary tables, spools, hashes, etc. are not tied to any specific database. For example, assuming we wanted to have a separate temporary work area for each...

Temporary tables, spools, hashes, etc. are not tied to any specific database. For example, assuming we wanted to have a separate temporary work area for each databases, if you have...

ScottPletcher (10/12/2015)

---

Eric M Russell (10/12/2015)

---

Kristen-173977 (10/9/2015)

---

Eric M Russell (10/9/2015)

---

Stuff like aliasing column names and stripping quotes from column values can be easily handled within the view or stored procedure, from...

Meatloaf (10/12/2015)

---

Hi, I am working with a SSIS Execute SQL Task and would like to see the results of my query. Is there a way to write the...

I could see a scenario where new hardware is purchased for the database server, and the old hardware ends up donated to the Development team or for sale on the...

If nothing else, TDE protects IT from the intrusion of nosy compliance auditors. However, as you know, there are other options for implementing data at rest encryption that might work...

When it comes to data governance, in the absence of any preexisting official documentation and governance, there simply is no deterministic truth. You're attempting to measure something that is subjective...

This was our philosophy when we built Chaos Monkey, a tool that randomly disables our production instances to make sure we can survive this common type of failure without any...

Kristen-173977 (10/9/2015)

---

Yeah, but...

The following doesn't use an UDF or CLR, and seems to cover all the (4) scenarios you described above.

declare @Invoice as table( BillID varchar(20) primary key );

insert into @Invoice...

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

So this should work:

object_name( @@procid )

SQL_Surfer (10/8/2015)

---

I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables. But...

You can do a brute force dictionary query against the sys.sql_logins table.

http://www.sqlservercentral.com/Forums/FindPost1623412.aspx

When I say ad-hoc queries, I'm referring to scenarios where users are typing SQL into a query tool ad-hoc, or perhaps where an application has a search feature with an...