SQL Server Password Management:
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.
Steve Jones bimonthly car update looks at driving in the UK and the differences in cars between the US and elsewhere.
A web look up of a huge list of stock symbols from an MS SQL database.
Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
Software Development Innovations is offering SQLServerCentral.com members a 20% discount on their products with a coupon of "sqlservercentral" used in their cart.
This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.
Project REAL was an amazing undertaking by Microsoft to put SQL Server 2005 to the test in a real environment. One of the main people working on this was Len Wyatt, who agreed to take a few minutes and share some thoughts with us.
It's not a string manipulation article in T-SQL, but it is SQL Server related. Check out what Steve Jones has in store for the PASS 2007 Summit for the SQLServerCentral.com community..
XML is becoming more pervasive in all of MIcrosoft's product, including SQL Server. Jay Dave brings us a short look at how one of their lesser known tools, the XML Notepad, can be used by SQL Server DBAs.
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers