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.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Tlp/WA.(+62 821°3111°179 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
BCA KCP Buaran Raya Telp/WA.0851°8812°0691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
Tlp/WA.(+62 821°3111°179 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers