Automating Red Gate SQL Compare with MSSQL Server Agent
How to compare two databases and email the results to every one who needs to know
2014-10-29
1,876 reads
How to compare two databases and email the results to every one who needs to know
2014-10-29
1,876 reads
As a society, we have an unrealistic respect for data, especially if it has a decimal point somewhere and uses metric units. We who are in the business of data need to cultivate a renewed interest in the sceptical and rigorous science of statistics: it is too important to leave to 'Data Scientists'. If the data is wrong, or the way we analyse or report it is misleading, much of what we do is pointless.
2014-10-28
8,058 reads
This metric is a great general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.
2014-10-28
7,321 reads
This article demonstrates the use of custom code and cell expressions referencing that custom code to toggle the background color of groups of rows in an SSRS report based upon value-changes in one of the fields.
2014-10-27
34,875 reads
Big data applications are now fairly commonplace in large organizations. It is, however, difficult to simply ‘drop’ these applications into an existing IT infrastructure and expect to run smoothly. In addition to energy and cooling requirements for new hardware to support the new big data application, other IT areas need to prepare.
2014-10-27
9,144 reads
DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.
2014-10-24 (first published: 2012-11-08)
22,146 reads
The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.
2014-10-24
2,184 reads
What do Technical Architects (TAs) actually do when in a development role? Are they just senior developers 'pushed upstairs' into a management role? Is there a clear distinction between a TA and a product, or project, manager? In an increasingly automated and joined up development environment, the role is important, varied and wide-ranging; as Grzegorz Strzelecki explains.
2014-10-24
11,772 reads
If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it
2014-10-23
16,437 reads
NuGet has transformed the ease of getting and installing the latest version of .NET packages, tools and frameworks. It relies on NuGet package authors to get packages right but there is little documentation for them to go by, and there are a few inevitable problems. Ed Charbeneau offers advice from experience.
2014-10-23
8,393 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers