Finding lost or forgotten SQL Servers
This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.
2013-07-29 (first published: 2011-04-19)
15,673 reads
Articles
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.
2013-07-29
194 reads
Using Lookup Function to Bridge Datasets in Report Builder
The report function, lookup, can be used to link two independent datesets.
2013-07-29
15,799 reads
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.
2013-07-29
3,398 reads
2013-07-26
617 reads
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.
2013-07-26
4,024 reads
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.
2013-07-25
2,810 reads
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.
2013-07-25
4,301 reads
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.
2013-07-24
3,805 reads
Are my actual worker threads exceeding the sp_configure 'max worker threads' value?
Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really explain and so worked with him to uncover what was happening under the covers.
2013-07-23
3,177 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Cara menutup kartu kredit UOB Cara menonaktifkan kartu kredit UOB
Untuk menonaktifkan dan menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp...
BCA KCP Buaran Raya Telpon/WA:085188120691
BCA KCP Buaran Raya Telpon/WA:085188120691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Prima Sunter Call CSO; (+62 821°3111°179
Jl. Danau Sunter Utara No.A2-A3, Sunter Jaya, Kec. Tj. Priok, Jkt Utara, Daerah Khusus...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers