SQL Server can store binary large objects such as files inside the database. Why might you want to store files inside the database? What problems might it cause and what alternative options should you be considering? I have experience managing several large SQL databases consisting of up to 160TB …
All monitoring tools have some overhead associated with them but generally, the overhead is low compared to the value they deliver. How much load does DBA Dash add to a server? To find out I setup an extended event to capture the queries ran by the DBA Dash agent. I left the trace running for over …
sp_WhoIsActive and sp_BlitzWho are popular stored procedures created by the database community. They both capture queries currently running on your server. If you are a seasoned DBA it’s likely you have come across one or both of these tools. sp_WhoIsActive in particular has been around for a very …
There are a few methods you can use to get drive information using T-SQL. The problem is all these methods have some limitations. They provide free space but not drive capacity or they only provide data for volumes that contain database files. Ideally Microsoft would provide an easy way to get both …
When you configure your SQL servers for high availability you want the failover to be as seamless as possible. If you use availability groups, mirroring or log shipping as part of your high availability strategy you will need to take care of anything that lives outside the context of your databases. …
Max server memory is one of the SQL Server configuration options that you should change from the default value. Brent Ozar has some good advice on this here. TLDR: You should leave some extra memory for the o/s. A good starting point is to leave 10% (4GB minimum). If you are running other processes …
WiseSoft.co.uk was created back in 2008 as a way for me to share scripts and applications with the community. I developed the website myself using .NET and created my own content management system that would make it easy to add new scripts, applications and articles to the website. At this time I …
My old website had an online syntax highlighter tool. I’ve since migrated to WordPress and I’m no longer able to host this tool. I’m posting the source code used instead - there are probably more sophisticated options available, but hopefully someone will find this useful! Use the FormatCode method …
Update active directory user attributes from a CSV File. (See Notes section for additional information and instructions) Notes This script can be used to update Active Directory User attributes from a CSV file. One column in the CSV file is used to match rows in the CSV file to user accounts in …
Extract user data from Active Directory as a CSV file. Handling for terminal services attributes is included. Notes This script expands on the Extract User Data to a CSV script by adding support for terminal services attributes. Terminal services attributes are actually stored in the …