Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.
Today Steve Jones talks about the gaps in our knowledge and our skill sets. He asks which things you think that all data professionals should be learning.
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.
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
Comments posted to this topic are about the item Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers