In a previous tip on Backup and Restore SQL Server databases programmatically with SMO, you've seen how you can use Windows PowerShell to backup and restore SQL Server databases. In this tip, I will cover how to use Windows PowerShell to generate SQL Server backups
Display data series' as a set of points with an XY (scatter) chart - typically to compare distinct values across categories. BI Architect Bill Pearson leads the hands-on creation of an XY chart based upon an Analysis Service data source.
An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired of endlessly flicking through reference manuals and having to work so hard just to formulate his queries. So he decided to build a cross-platform Query Template solution to make his life easier, and he even went as far as building a .NET control to be integrated into applications. He's been kind enough to share the control, and the theory behind it, with us.
While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, continuous queries, and millisecond latency requirements that make it impractical to persist the data in a relational database for processing. These requirements are shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring. Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships and data abstractions from among seemingly unrelated events and trigger immediate response actions.
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers