SQLServerCentral Webinar #24: Prepare for When Disaster Strikes
Steve Jones presents some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.
Using Lookup Function to Bridge Datasets in Report Builder
The report function, lookup, can be used to link two independent datesets.
VMware High Availability in SQL Server
With the massive number of servers running SQL Server within virtual machines (VMs), it's critically important for DBAs to understand the high availability options available when SQL Server is running within a VM.
PowerShell the SQL Server Way
Although Windows PowerShell has been available to IT professionals going on seven years, there are still many IT pros who are just now deciding to see what the fuss is all about. Depending on your job, you might find PowerShell an invaluable tool. Microsoft's plan is that PowerShell will be the management tool for all of its servers and platforms. For most IT pros, it's not a matter of if you'll be using PowerShell, only a matter of when.
Data Farming
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
AlwaysOn in SQL Server 2014 CTP1
AlwaysOn encompasses the SQL Server solutions for mission-critical high availability and disaster recovery. Two solutions were included under the AlwaysOn umbrella in SQL Server 2012: Availability Groups and Failover Cluster Instances. Each solution has different characteristics, making them appropriate for different scenarios, and both can be combined in the same deployment.
Disaster Recovery Tip #6 - Monitor Your Systems
Today's complex systems are too large to be able to rely on any DBA's memory for knowledge of each component, and its configuration options and settings.
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
Rendering images from a database on SSRS reports
Looking for a way to put images on SSRS reports and allow the business users to change the images every so often? This article explains how to implement this in such a way that you don't have to modify a report when the image is changed.
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers