Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually get out of sync with the underlying tables. In this article, Edward Pollack shows how to overcome this problem.
2020-04-21
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
2020-04-20
In the immortal words of “Orange” Julius Caesar as written by Shake’s peer, “Beware the bugs of March.” It took us 2,064 years, but we’ve finally fixed those bugs, plus added a couple of new features.
2020-04-17
In this tip I will demonstrate a simple way of launching a SQL Agent job when the job it depends on completes successfully.
2020-04-16
The State of Database Monitoring survey is open. How are you currently monitoring your database estate? Are you working cross-platform? Tell us your opinions in our annual survey on the State of Database Monitoring for your chance to win a $500 Amazon voucher.
Take the survey.
2020-04-16
No matter where you run your SQL Server® instances—on-premises, in a virtual machine, or in an Azure SQL Database Managed instance—the challenge is the same. How do you ensure you get optimum performance? Is the virtual machine impacting your database instance performance? Which queries cause the most blocking or deadlocking? Are you consuming more DTUs in your Azure SQL Database than you budgeted for?
2020-04-15
SQL Monitor 10.0.5 now supports a user role called "Reports user". A user added to this role, by an administrator, will be able to 'self-serve' SQL Monitor reports but won't be able to configure any other aspect of the monitoring service. Jeremiah Peschka explains how it works.
2020-04-14
While Microsoft provides a number of different deployment options for its Azure SQL Database offerings, one in particular warrants special attention from the standpoint of its infrastructure dependencies: Azure SQL Database Managed Instance.
2020-04-14
We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.
2020-04-14
Grant Fritchey explains the core rules and features of Data Masker, and how you go about using them to mask columns, so that when the data is used outside the production system it could not identify an individual or reveal sensitive information.
2020-04-13
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Comments posted to this topic are about the item Getting the Object Code
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Being Mindful of Design Time
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers