In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.
Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
You already have a SQL Server Reporting Services (SSRS) sales report that takes parameters for Country and State. Each time the report is run a user selects the specific Country and State for the report. A request has been made to deliver one report via email that includes all of the combinations for each country and state. Daniel Farina shows how to achieve this without modifying the report.
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers