WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.
Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.
Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.
In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.
Steve Jones is searching for anyone that is using In-Memory OLTP tables in production.
Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.
Alex Kuznetsov, in an article taken from his book 'Defensive Database Programming with SQL Server', shows how DRY principles can be put in practice with constraints, stored procedures, triggers, UDFs and indexes.
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers