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
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...
Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan, Kalimantan Utara...
Tlp/Wa_Cs:0817-866-887 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan,...
Tlp/Wa_Cs:0817-866-887 Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18, Sunter Agung, Kec....
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