Monitoring SQL Server Agent with Powershell
This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.
2009-03-31
3,061 reads
Articles
Using FOR XML clause to generate KML
Creating KML files for many of the GIS applications such as Google Earth can be an easy and rich part of your business intelligence efforts
2009-03-30
8,634 reads
Combining SQL Server & Flash Technologies - Floor Plan example
Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business for local utilities giant Hydro Quebec, by developing a web site for the twenty-first International Commission on Large Dams' congress in Montreal, where it was hosted in 2003.
2009-03-30
2,257 reads
Connecting Oracle BI Publisher to SQL Server
One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.
2009-03-30
1,937 reads
Dropping multiple objects with a single DROP statement
Most SQL Server users drop one object at a time using either SSMS or a single drop statement. In many scenarios we may need to drop several objects of the same type. Is there a way to drop several objects through less lines of code?
2009-03-30
4,719 reads
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
2009-03-30
460 reads
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
2009-03-30
699 reads
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
2009-03-30
453 reads
Tip for determining I/O Heavy Queries
When it comes to performance tuning, locating the problem index is one of the first steps and being able to very quickly narrow the focus of your efforts makes for a much more efficient DBA.
2009-03-27 (first published: 2007-11-06)
26,235 reads
SQL Q & A: Database Consistency, Temporary Tables, and More
Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.
2009-03-27
4,251 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers