This article covers SQL Server 2008 Service Broker, an asynchronous messaging framework that is directly integrated within the relational engine of SQL Server. The series will provides you with the basics about implementing Service Broker applications and how you can transparently scale them out to support any required workload.
Redgate have launched their very own Online SQL Formatter powered by SQL Prompt. Visit the page here to try formatting your SQL code with a few pre-defined styles, or find out how to create and share your own styles with SQL Prompt.
In this article we look at how you can easily build virtual desktops that you can deploy to your teams using Amazon WorkSpaces.
Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure.
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
The differences in our understanding of technologies can make for some communication challenges.
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
One of the challenges of using scripts is maintaining them and ensuring the adapt over time.
In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?