An Interesting Article on Unicode and Character Sets
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
Regular columnist Robert Marda discusses a few ideas on stored procedure documentation. How much documentation do you need and is "documentation" different than code comments?
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
Another adventure in the real world. Steve Jones tracks down a problem with locks on a live system. Read along and see how he works through the issues.
We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.
Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
xSQL Object for Microsoft SQL Server has been designed with the DataBase Administrator in mind. Scripting, Comparing and even Synchronizing different objects like tables, views, stored procedures etc. is fast and easy.
In this follow up article, Haidong explains how to audit DTS packages. While parts of it are specific to DTS, the general technique has many useful applications.
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers