Will Terminators Be Required?
The use of terminators in T-SQL is incredibly inconsistent. Steve Jones thinks it will always be this way.
How to Successfully Deliver IT Projects in a Not-so-Agile Organization
Agile methodology for software delivery is accepted at many organizations but is not used everywhere. In this article, Mohammad Rizvi gives advice on how to successfully implement a software project in a non-Agile environment.
Is SQL Server Mature?
This Friday Steve Jones is wondering if the SQL Server platform does the job well enough for most people, or are there holes that need to be filled with new features.
SQL Authentication Via AD Groups Part II: Who has what access?
In a previous article, we discussed how to liberate the DBA from SQL Logins with AD Groups. A good point was raised: How can the DBA know who has what access? Here is a solution.
Interpreting Missing Index Recommendations
Pinal Dave explains how missing index hints are like restaurant appetizers.
Handling Inconvenient Requests
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
Using a Derived Table to Compare Data with Values from a Previous Year
Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL
Understanding your Azure EA Billing Data and Building a Centralized Data Storage Solution
Many organizations are moving to Azure and other cloud providers. Understanding how resources are being used and what is spent is very important. In this article, Feodor explains his solution for automating the collection of the Enterprise Agreement billing from Azure into an Azure SQL Database where it can be analyzed.
CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
Rolling up multiple rows into a single row and column for SQL Server data
Do you need a way to roll-up multiple rows into one row and one column. You know you can roll-up multiple rows into one row using Pivot, but you need all of the data concatenated into a single column in a single row. this tip looks at a simple approach to accomplish this.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers