When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.
One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.
SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.
When you deploy software, what do you do if things don't go well? Steve Jones talks about a few options you might have.
In this article, Koen Verbeeck illustrates how to add a linear trendline to a graph in SSRS, similar to the way it would appear if done Excel.
If your application relies on identity columns, this metric is a useful measure of the number of identity columns that are near to the limit per database. You can then avoid logical problems in your application and SQL Server errors.
Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.
Conference travel enhances our minds with more than just SQL. It exposes us to new cultures, people and possibilities.
What helps people be successful in a company? Perhaps a little analytic work can help employers determine this.
Force.com is an enigma; a Platform-as-a-Service that is designed to appeal to a broad church of developers, to make it quick and easy to write simple cloud-based applications. Robert Sheldon explains, as simply as possible, why this unusual data-centric, and metadata-driven platform is attracting so much interest in the industry.
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers