Despite all the coders contributing to OpenSSL, they somehow missed an obvious buffer overflow bug that could be spotted in a production or test environment without even examining at the...

Steve Jones - SSC Editor (4/24/2014)

---

jarick 15608 (4/24/2014)

---

The push needs to come from someone in senior management with some security smarts. In my experience, very few executives have this...

Unfortunately there are many IT shops who treat their relational database like a digital landfill: no thought for normalization, constraints, or optimization. Archived emails, website clicks, basically...

Yeah, we get the joke, but at this point you could...

jarick 15608 (4/24/2014)

---

I did something like this only to learn that we were out of compliance with a vendor and had broken a support agreement. This was a large...

Another disadvantage of using triggers in place of constraints is that a newly created trigger won't validate existing rows, only newly inserted or updated rows. Also there are more scenarios...

If a software application is hard coded to use the "SA" account, you can rename it and then create a new account named "SA" with limited permissions. One or more...

It's amazing that googling the following will still return hundreds of actual server login credentials.

filetype:config connectionString uid password

Also SORT_IN_TEMPDB = { ON | OFF } depending on which filegroup (default or tempdb) has available free work space.

I believe that performing a clustered index reorganization is always an online operation, and LOB_COMPACTION (on by default) will also reclaim deallocated LOB pages, which is what Kumar really needs.

What...

Also, for sizing up a table that includes nText and nVarChar(max) columns, the sys.dm_db_partition_stats view can be used to return more detailed information about In Row allocation versus LOB and...

S_Kumar_S (4/23/2014)

---

ok, now the direction of problem changed totally after some findings. The clustered index was actually not rebuild by the maintenance job because table has a ntext column!!

And...

djj (4/23/2014)

---

Hello, Is there a difference in the following: DECLARE @T1 VARCHAR(50);

SET @T1 = (SELECT TOP(1) Col1 FROM MyTable); -- define variable first way

SELECT TOP(1) @t1 = Col1...

Of course, by breaking the MCM mold, Microsoft has insured that these minted certifications are now even more exclusive and valuable. 🙂

Given the cirsunstances, it's probably best to just hard code the definition of the temp table, which is the typical way of doing it. I wouldn't even dick around with...