BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group, with the Ancestor() and .FirstChild functions.
In this article you will see the detailed steps needed to implement the log shipping for large databases.
In this free webinar you will learn how to effortlessly source control your database using SVN, TFS, Vault, Vault Pro, Perforce, Mercurial, GIT, and Bazaar to name just a few, in fact any source control system with a command line. See how to download, install and share changes in under 5 minutes.
The AppStore model is one that Steve Jones likes, but he'd like to see it slightly more open over time and allow other companies to vet applications that users can then install on any system or device.
This is the first of three tips on how ETL Developers can be more productive by applying custom SSMS shortcuts to the most often used tasks.
The SQLServerCentral webinar series continues with Steve Jones talking about the ways you can recover from disasters with a little preparation.
Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil Factor for advice, thinking that it would be a simple explanation.
Jeff Moden has been elected as the Exceptional DBA of 2011. Here, Jeff talks to Bob Cramblitt about the life of an exeptional DBA.
As we look to take more data from customers and clients and embed it in our applications, data quality becomes a bigger issue
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Whatsapp 087781685647 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
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
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