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.
Practicing Deployments
Amateurs practice until they can get something right. Professionals practice until they don't get things wrong. How should we handle our deployments?
Introduction to SQL Server Stretch Database
In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
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...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
ALAMAT BCA KCU SUBANG Telp:08218154393
WA:08218154393 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers