Double Checks
Many of us have checks in place on systems or processes, but would we be aware of tampering with the operation of our computer systems? Steve Jones notes that auditing can be important to ensure things are working well.
New SQL Monitor Custom Metric: Default User Service Account
Using a default account for SQL Server services can be a security risk for two reasons. Firstly, it can give the service a higher level of permissions than it needs. Secondly, isolation is compromised by several services running under the same account. This metric checks whether SQL Server services are running under any of the default accounts, such as localsystem.
SQL Enlight for SQL Server Management Studio
The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.
No Bosses
The idea of not having a boss appeals to many of us, but is it really what you'd like? Steve Jones notes that Zappos is trying this, by eliminating many of the manager roles at the company.
The Art of Performance
Tuning a SQL Server instance and improving the way it performs is a complex task that many people struggle to complete. In this piece, Steve Jones talks about the idea that it is a science as much as an art.
Agile Database Development
Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software engineers.
Cleveland, OH - SQL in the City Seminar - Deployment Stairway
Grant Fritchey and Steve Jones will be hosting a free seminar in Cleveland on February 7 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment.
Fuzzy-String Search: Find misspelled information with T-SQL
An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008
The Desktop Setup
This Friday Steve Jones asks about how you set up your hardware and software environment for work. Are there things you recommend?
Stop & Start Your VM’s on Azure with Powershell
This is a very simple script can be used as a framework for you to stop and start your VM’s on Azure with Powershell.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers