Technology Musings
In: SQL Server
19 Aug 2008A T-SQL query to verify the size and growth settings for a SQL Server database without resorting to the Management Studio GUI.
Sitting on my couch one night, I noticed that the time on my laptop was about 10 minutes slow compared to every other time source in my house (mobile phone, cable box, etc.)… Since I’m running a domain environment, I knew that most of my OS installations would be syncing to the domain controller, so I [...]
In: SQL Server
15 Aug 2008Ever needed to round an arbitrary DATETIME to some specified increment (i.e. 5, 10 or 15 minutes)? This function can come in handy for such a task.
Some time ago, I needed to sync down a list of AD users to use as a lookup (as opposed to querying LDAP on demand). I found this little gem: How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code. It works great, especially since I submitted [...]