How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
Parameterized Queries
A Greg Larsen classic - he discusses how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
Creating Inferred Dimension Members with SSIS
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
How Do You Find a DBA?
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Reporting Services Performance and Optimization
This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.
Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
It’s About the Journey, Not the Exam
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
Terrifyingly Accurate Technology Predictions for 2014
The end of a year is a time for reflection, but it’s also a time for running full-pelt at the new year with some ill-thought-out predictions under ones belt. It’s with this in mind that I fire up my 100%-accurate Criswell-Brand crystal ball, and peer into next year’s world of technology.
Blogs
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...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT BCA KCU JOMBANG Telp:08218154393
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
ALAMAT KONTAK BCA KCP Krian Telp:08218154393
WA:08218154393 Jl. Kauman No.25, Magersari, Krian, Kec. Krian, Kabupaten Sidoarjo, Jawa Timur 61262
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers