In a previous article, we discussed how to liberate the DBA from SQL Logins with AD Groups. A good point was raised: How can the DBA know who has what access? Here is a solution.
2018-08-03 (first published: 2016-02-18)
10,075 reads
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
2018-02-02 (first published: 2015-12-21)
8,587 reads
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,120 reads
I am trying to import a text file (a log file generated by another program) into SQL. The log file on the face of looks nicely formatted, however upon closer inspection, they are not tabs or spaces but multiple spaces! the number of spaces can differ widely depending on the first columns value. Thus when I […]
2005-01-04
76 reads
so far 27 people answered "C"... if any of them can read this message, please explain!
2004-09-07
You should set off your Profiler and then disconnect instead of logging off in terminal services. When you log off your session closes and anything you are doing stops too. Just pick disconnect. However, this will hold a session open and could potentially cause others to not be able to TS into the box.
2004-08-27
Thanks for the input. We will try this. We were hoping to be able to use a ram disk with the NUL Device, so this looks like the best option for our situtation.
2004-08-25
does anyone know of a way to easily track database growth over a period of time?
2004-07-23
928 reads
I am a fan of using Identity columns as primary key and then if appropriate using the "natural" key as unique clustered index. Since the promary key is what should be used as a foriegn key I don't like the idea of having that piece of data editable. Also witha a composite key there are […]
2004-02-06
Don't use the table names in the select list:CREATE VIEW IMEXtrlrUtilUNIONasapSM_VW as SELECT top 100 percent OrderNbr, City, Shipper, Weight from IMEXtrlrUtilShipMat_VW Union select top 100 percent OrderNbr, City, Shipper, Weight from IMEXtrlrUtilASAP_VW ORDER BY OrderNbr, City, Shipper For the record, even if not including and Order By clause, I advocate never using Select * […]
2004-01-20
As a Software Engineer, I would like to replicate a copy of my database...
I have heard about many interesting things about programming in Rust and I decided...
A recent Microsoft outage caused by a bad patch pushed out to Windows instances...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers