Restore Gene Version 6 - User Guide
Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.
Direct Query with Power BI
Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on extremely large datasets where re-importing data not a practical solution. It also allows you to do data aggregations on the server. There are, of course, restrictions as well but it is nevertheless a worthwhile technique to use where appropriate. Adam Aspin explains all.
Creating Partition on Existing tables and Rolling Partitions
this article describes about creating partitions on our existing Tables and also gives details about how to create rolling partition to support new data
Ignoring Database Version Control
Steve Jones thinks version control is important, even for databases.
Teaching a dog to sing
To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.
Real-time Operational Analytics in SQL Server 2016 - Part 1
Arshad Ali takes a look at traditional analytics architecture, the challenges it faces, and how the newly introduced Real-time Operational Analytics feature overcomes those challenges.
A Case FOR Cursors...
We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."
Impressive Accomplishments
What things impress you most about potential candidates. This week Steve Jones asks the question to try and understand what types of activities data professionals might consider.
How to tell what SQL Server version you are running
Gerg Robidoux demonstrates a couple of methods for determining which version of SQL Server you're running, as well as what service pack or hotfix is installed.
Azure SQL Database – How to Choose the Right Service Tier
So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Murilo Miranda provides a simple guide to get started.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pluit Samudra Tlpn/Wa 0853.7373.7551
Jl. Raya Pluit Utara. 85 Blok E Kav. No. 11, RT.4/RW.5, Pluit, Kecamatan Penjaringan,...
BCA KCP Tebet Timur Telpon/WA:08137887595
BCA KCP Tebet Timur Telpon/WA:08137887595.Jl. Tebet Timur Dalam Raya Blok GG No. 97, Tebet...
BCA KCP Gading Riviera Tlpn/Wa 0853.7373.7551
Jl. Raya Kelapa Hibrida, Ruko, Jl. Gading Riviera Raya No.10 Blok PF 21, Daerah...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers