SQLServer 2008 R2 SP3 released, Now its testing and deployment time!
As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and...
2014-09-29
1,438 reads
anup.varier@gmail.com
- Website: http://sqlsailor.com
Building a Virtual Machine within Azure (IaSS) – Improvements !
Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows...
2014-08-18 (first published: 2014-08-12)
7,408 reads
Microsoft Azure Portal Preview looks promising !
This is one of those posts which is pending for a very long time. I was pretty excited when Azure...
2014-06-26
945 reads
Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,949 reads
Data Collector in SQLServer 2014 – What’s New !
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,787 reads
SQL Server 2014 Install – Step by Step
Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh...
2014-04-01
19,245 reads
Folks,Know your Outbound Data Transfer Costs – Windows Azure
The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.
Yes, when I...
2014-03-25 (first published: 2014-03-19)
2,682 reads
Rollback DBCC CHECKDB REPAIR !
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,567 reads
One error which you don’t want to see while doing upgrades – Missing MSI !
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,206 reads
Setting up the Min and Max Memory options on the fly – Word of caution !
Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...
2014-01-02
829 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers