When a SQL expert moves from Oracle to SQL Server, he can spot obvious strengths and weaknesses in the product that are too familiar to be apparent to the SQL Server DBA. Jonathan Lewis is one such expert: In this article he records his train of thought whilst investigating the mechanics of the SQL Server database engine. The result makes interesting reading.
May 10, 2010, 11:30CST. Now that you have created your SSIS packages it’s time to add some configuration files that will ease your deployments. Wait how do you deploy one or two or three SSIS packages? Uh oh, now that they are deployed how do you schedule them? Well join Patrick LeBlanc in his discussion on how to Configure, Deploy and Schedule your SSIS packages.
Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.
This Friday we have a fun poll. What interesting descriptions do you use when trying to talk about code with your peers?
I have installed a new instance of SQL Server 2008 Analysis Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Analysis Services features in SQL Server 2008?
Here's one that you might want to pass along to those managers that approve training. Steve Jones gives you the reasons why you ought to consider paying for training.
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.
This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.
When is it worth making an investment to learn a new technology? Steve Jones comments on Powershell as one of those technologies that he has been slow to begin using.
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...
CSTelpon : 0853-73737551 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan...
CSTelpon : 0853-73737551 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Jl. Gatot Subroto No.42 Suite G02, Kuningan Bar., Kec. Mampang Prpt., Kota Jakarta Selatan,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers