It is important to ensure that SQL code is laid out the best way for the team that has to use and maintain it. Before you work out how to enforce a standard, one has to work out what that standard should be for the application. So do you dive into detail or create an overall logic to the way it is done?
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
Diagnostic report pack for SSRS that provides monitoring capabilities for all items on the Report Server.
A guest editorial from Brad McGeHee today talks about maintenance plans and his new book.
The company I work for has migrated to SQL Server 2008 and we're ready to start planning for the use of geospatial data. One of the applications we want to use geospatial data in will assist order fulfillers in efficiently picking stock for orders. Our warehouse is fairly large, which geospatial data type should we use?
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
A guest editorial today from Simon Galbraith, founder of Red Gate Software talking about SQL Search, a new product that was developed in an interesting way.
If so why? Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008,...
Join BI Architect Bill Pearson in this introduction to Security in Analysis Services 2008. Here we explore security concepts and implementation, and look forward to hands-on practice with security in other articles of this subseries.
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...
WhatsApp:0818-751-777 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212 (@bcakcpbrebes)
Comments posted to this topic are about the item Midjourney, Healthcare?
Comments posted to this topic are about the item Changes, Happiness, and a Few...
When running bcp on Linux, what is the field terminator?
See possible answers