Blog

Blog

  • The Agentic Enterprise, October 2026: The Framework I Wish I’d Had

    This month: the Agentic Architecture Framework in plain English, a worked data-readiness example, and a subscriber-exclusive maturity self-assessment.

  • How Executives Should Approach AI: A CIO/CTO Field Guide

    Boards want an AI strategy, vendors promise transformation, and pilots quietly die. A field guide for CIOs and CTOs on the executive discipline that makes AI actually pay.

  • The Agentic Architecture Framework: A TOGAF-Style Method for AI & Data

    TOGAF gave enterprise architecture a shared language for the deterministic era. The agentic era needs its own — a practitioner’s framework with 12 principles, a six-phase delivery cycle, and governance mapped to NIST AI RMF.

  • Building a Data Lake That Earns Its Keep: Lessons from Billions of IoT Rows

  • Welcome to The Agentic Enterprise

    If you’re reading this in your inbox, you’ve been subscribed to aiDeeva for a while — thank you. You’ve been getting new posts as they publish. Today I’m giving this newsletter a proper name and a proper promise. The Agentic Enterprise is a monthly note on production AI, agentic systems, and the data architecture behind…

  • RAG in Production: What the Demos Don’t Tell You

    The demo is always magical. You point a retrieval-augmented generation system at a pile of documents, ask a hard question, and get a fluent, sourced, correct answer. The room nods. Someone says “we should ship this.” And then production happens — and production has questions the demo never asked. I have built RAG systems that…

  • Legacy to Cloud-Native: A Database Modernization Playbook

    Database modernization is where cloud migrations go to get hard. Applications can be containerized, rehosted, refactored — but databases carry the data, the transactions, and the business’s tolerance for downtime, which is usually near zero. I have worked on massive database migration programs, including estates of tens of thousands of SQL Server and Oracle databases,…

  • The Real Cost of Cloud Migration — and How to Control It

    Every cloud migration I have ever seen has two budgets: the one in the business case, and the real one. The gap between them is where careers get uncomfortable. It is rarely caused by one big mistake. It is caused by a dozen small leaks that nobody owned — over-provisioned instances, architectures chosen for speed…

  • What Operating 17,000 Databases Taught Me About Data Architecture

    Nobody ever sat down and designed a 17,000-database architecture. You don’t arrive at that number through planning. You arrive at it one acquisition, one new application, one “temporary” database at a time — until one morning you realize the fleet has quietly become the largest thing in the building, and every shortcut anyone ever took…

  • Have You Ever Thought About Vibe Coding Your Own Database Engine?

    DATABASE ENGINEERING   /   AI-ASSISTED DEVELOPMENT From a college project written in C to architecting a relational database engine with AI. Jugal Shah   |   Database & AI Architect   |   aiDeeva What if you could build your own database engine? During my college days, I built a simple invoice management system…

  • Beyond the AI Hype: The 3 Breakthroughs Needed to Reach Next-Gen Intelligence

    Every week, the tech world gets flooded with headlines about new model releases, benchmark scores, and trillion-parameter claims. But if you look past the marketing noise, a deeper question emerges: What is actually holding AI back from making its next giant leap? If we want AI systems that don’t just chat, but actively solve massive…

  • What Is a Graph Database—and Why Does It Matter in the Age of AI?

    From Connected Data to Intelligent Action — Part 1 Enterprises do not suffer from a shortage of data. They suffer from a shortage of connected understanding. Customer information may live in a CRM. Product information may be stored in an ERP system. Contracts may exist as documents. Operational events may arrive through streaming platforms. Application…

  • Agentic AI Boot Camp: A Hands-On Journey

    I just finished an intensive, hands-on boot camp on agentic AI and it exceeded my expectations. Over the course of the program I moved from curiosity to practical capability — building small, testable agents, understanding safety tradeoffs, and shipping reproducible experiments. If you’re curious what a focused, project-driven AI boot camp looks like, here’s a…

  • The Architect’s Dilemma: A Defensible Framework for Agentic ROI

    Meta Description: By 2026, 40% of apps will be AI-agentic. Learn how to bridge the 89% adoption gap and drive EBITDA-positive AI transformation with our executive framework. The AI Transformation Reality Check In 2026, the “AI curiosity” phase has officially ended. Gartner reports that 40% of enterprise applications will feature autonomous agents by year-end, yet…

  • AFK AI Coding with “Ralph”: Let Your AI Code While You’re Away

    If you’re using AI coding CLIs like Claude Code, Copilot CLI, OpenCode, or Codex, this article is for you. Most developers use these tools in an interactive way. You give a task, watch the AI work, correct it when needed, and move forward. This is the familiar human-in-the-loop (HITL) style of AI-assisted coding. But there’s…

  • AI Governance Board is must now for each organization

    Designing a robust AI governance structure requires a seamless flow from a localized “idea” to centralized “oversight.” In 2026, this isn’t just a bureaucracy—it’s a production line for safe, scalable innovation. Here is the step-by-step architecture for your organization’s AI Governance journey. Step 1: The AI Intake Form (The Gateway) The journey begins with a…

  • Build vs Buy in the Age of Vibe Coding

    Why Teams Still Choose SaaS Platforms Like Salesforce or HubSpot With modern frameworks, cloud infrastructure, and AI-assisted “vibe coding,” building software has never felt easier. A small team can spin up a CRM, dashboard, or workflow tool in weeks—not years. So the natural question arises: Why do companies still pay for SaaS platforms like Salesforce…

  • Palantir – $PLTR

    Many retail investors and hedge fund invested in $PLTR. Question is what Palantir actually do and what business challenges they solve? Palantir Technologies builds enterprise-grade data, analytics, and AI platforms used to make high-stakes decisions in complex environments. In simple terms:Palantir helps organizations integrate messy data, analyze it at scale, and turn it into actionable…

  • AI-Free Meetings: A Strategic Reset, Not a Step Back

    Pros, Cons, and When It Makes Sense AI has rapidly entered every corner of modern work—from meeting notes and summaries to real-time suggestions and follow-ups. While these tools undeniably improve efficiency, an important question is emerging for leaders and teams: Are we optimizing meetings—or outsourcing thinking? This has led some organizations to experiment with a…

  • When Do Multi-Agent AI Systems Actually Scale?

    Practical Lessons from Recent Research, must read : The AI industry is rapidly embracing agentic systems—LLMs that plan, reason, act, and collaborate with other agents. Multi-agent frameworks are everywhere: autonomous workflows, coding copilots, research agents, and AI “teams.” But a critical question is often ignored: Do multi-agent systems actually perform better than a well-designed single…

  • Why AI Projects Stall?

    In short answer is YES. 1. No clear business owner or decision Many projects start with enthusiasm but fail to answer: What decision or workflow is AI improving? Who owns the outcome? Without a business owner and success metric, AI remains a lab experiment. 2. Poor data readiness AI stalls when: Data is inconsistent, incomplete,…

  • How I avoid AI hype with customers?

    1. Start with the business decision, not the model I redirect conversations from: “Which model should we use?”to “What decision or workflow are we trying to improve?” If the decision, owner, and success metric aren’t clear, AI is premature. 2. Frame AI as augmentation, not automation I set expectations early: AI assists humans today more…

  • What must be true before AI is realistic

    1. Clear business use cases (not “AI for AI’s sake”) AI only works when: The decision or workflow to augment or automate is clearly defined Success metrics are explicit (cycle time, accuracy, cost, revenue impact) If the use case is vague, AI becomes experimentation, not production value. 2. Trusted, high-quality data Before AI, the platform…

  • Data Engineering ETL Patterns

    Data Engineering

  • Understanding Machine Learning: A Beginner’s Guide

    Understanding Machine Learning: A Beginner’s Guide Machine Learning (ML) is at the heart of today’s AI revolution. It powers everything from recommendation systems to self-driving cars, and its importance continues to grow. But how exactly does it work, and what are the main concepts you need to know? This guide breaks it down step by…

  • Lang Chain and Lang Graph

    1. Why Do We Need LangChain or LangGraph? So far in the series, we’ve learned: LLMs → The brains Embeddings → The “understanding” of meaning Vector DBs → The memory store But…How do you connect them into a working application?How do you manage complex multi-step reasoning?That’s where LangChain and LangGraph come in. 2. What is…

  • Vector Databases

    1. What is a Vector Database? A Vector Database stores and retrieves data based on meaning, not exact match.Instead of storing plain text, it stores vectors (embeddings) and finds which ones are closest to your query vector. Think of it as: Google for meaning It doesn’t care about the exact words, just the semantic similarity…

  • Understanding Embeddings

    1. What Are Embeddings? Imagine you want AI to understand that “car” and “automobile” are similar in meaning. Computers don’t inherently understand words — they understand numbers.Embeddings are how we convert words, sentences, or documents into numerical form, so AI can compare them mathematically. An embedding is: A vector (a list of numbers) Each number…

  • Understanding the Brains Behind Generative AI : LLM

    What is a Large Language Model (LLM)? Large Language Models (LLMs) are at the heart of modern Generative AI.They power tools like ChatGPT, Claude, Gemini, and LLaMA—enabling AI to write stories, summarize research, generate code, and even help design products. But what exactly is an LLM, and how does it work? Let’s break it down…

  • Generative AI: The Creative Revolution Transforming Our World

    “The question is no longer Can AI create? — it’s What will we create together?” Generative AI is no longer a buzzword—it’s a global shift in how we imagine, design, and innovate. In just a few years, it has gone from research labs to everyday tools, allowing anyone—not just engineers—to create text, art, music, videos,…

  • Upcoming AI Content Roadmap

    🚀 Welcome to AIDeeva: Your Destination for Actionable AI, Startups, Training & Consulting AI is no longer optional — it’s foundational.Whether you’re a business leader, technical professional, or aspiring founder, the world is changing fast — and Generative AI is leading that change. That’s why I created AIDeeva.com — a blog and resource hub where…

  • How to Build a Custom AI Chatbot Using Open-Source Tools?

    AI chatbots are transforming the way businesses interact with customers and how individuals automate tasks. With the rise of open-source tools, building a custom AI chatbot has never been easier. In this blog post, we’ll walk you through the steps to create your own chatbot using popular open-source frameworks like Rasa, Hugging Face Transformers, and DeepSeek. Why Build…

  • DeepSeek Personal Data Training On-Premise

    How to Use DeepSeek for Personal Data Training On-Premise In today’s data-driven world, AI models like DeepSeek are revolutionizing how we process and analyze information. However, with growing concerns around data privacy and security, many organizations and individuals are turning to on-premise solutions to train AI models on their personal data. In this blog post, we’ll explore how you…

  • Types of Modern World Database Administrators

    1. System DBA Focus on the physical and technical aspects of database management. Install, configure, and upgrade database software. Manage the operating system and hardware that the database runs on. Monitor system performance and manage system resources. Implement and manage database security. Database Systems: Oracle, SQL Server, MySQL, PostgreSQL, DB2 Operating Systems: Linux, Windows, Unix…

  • Vector Database

    In today’s data-driven world, businesses are constantly seeking innovative solutions to handle complex and high-dimensional data efficiently. Traditional database systems often struggle to cope with the demands of modern applications that deal with images, text, sensor readings, and other types of data represented as vectors in multi-dimensional spaces. Enter vector databases – a new breed…

  • Machine Learning Basics and Foundations

    Machine learning, a subset of artificial intelligence (AI), has revolutionized the way we solve complex problems and make predictions based on data. From recommending products to detecting fraud and diagnosing diseases, machine learning algorithms are powering a wide range of applications across various industries. In this article, we’ll explore the basics of machine learning, including…

  • Generative AI Basics

    Generative AI Basics: Understanding the Fundamentals Generative AI, a subset of artificial intelligence (AI), has garnered significant attention in recent years due to its ability to create new content that mimics human creativity. From generating realistic images to composing music and even writing text, generative AI algorithms have made remarkable strides. But how does generative…

  • How PostgreSQL stores the oversized or extended fields?

    Recently I was loading the very large analytics data set to the PosgreSQL table and compare to the rows/tuples size, table has claimed the around 200X of the storage. Upon the investigation I found the issue related to toast bloating and have to reclaim the space. Let’s learn about the toast table in this article.…

  • PostgreSQL – .pgpass file

    .pgpass file in a user’s home directory or the file referenced by PGPASSFILE can contain passwords to be used if the connection requires a password (and no password has been specified otherwise). On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user’s profile). This file should…

  • SQL Server 2016 : DBCC CheckDB with MaxDop Option

    What is Max Degree of Parallelism? Degree of parallelism is the number of processors that are assigned to run a single SQL statement. SQL Server manages to detect the best degree of parallelism for each query to generate the execution plan. SQL Server may use all the procedure in case if it required. If you…

  • T-SQL Script to get the Symantec NETBACKUP Version and Patch Information

    You can execute below script to get Symantec NETBACKUP version and patch information.

  • T-SQL Script to check Powershell Version

    You can write $host command on powershell prompt to check powershell version or you can execute the below T-SQL script to check the powershell version.

  • MongoDB Post Installation Configuration

    On the completion of MongoDB installation http://sqldbpool.com/2015/02/24/mongodb-installation-on-windows-server/, next step is to configure the MongoDB. Create a MongoDB config file using any text editor (e.g. NOTEPAD) and save it as MONGO.config into bin directory. Start MongoDB Server, make sure to open the command prompt as Administrator. Go to MongoDB bin directory and write the below command.…

  • MongoDB Installation on Windows Server

    You can download the MongoDB https://www.mongodb.org/downloads. Once you download the MongoDB (Version 2.6.7), follow below step by step to process to install MongoDB. Double click on mongodb-win32-x86_64-2008plus-2.6.7-signed.msi and follow below screen.     You will see the below files into MongoDB folder.

  • Script to list out SQL Logins and Database User Mappings

    You can use system stored procedure sp_msloginmappings to list out the SQL logins and database user mappings. Syntax sp_msloginmappings @Loginname , @Flags @Loginname – Optional argument, in case if you not specify the Login name procedure will return the result for all the SQL Server logins @Flags – You can specify value 0 or 1,…

  • How to restart an Interrupted Database Restore in SQL Server?

    Steps to restart an Interrupted Database Restore in SQL Server There may scenario when you are restoring VLDB database backup and the restore database command interrupted due network failure, power failure, SQL Server Service restart or cluster failover. In this kind of scenario you can easily start the interrupted restore from the point of failure…

  • Database Backup WITH CHECKSUM

    Backup WITH CHECKSUM When WITH CHECKSUM option is used while taking backup, the backup process will verify each page for checksums and torn page. In case bad page checksum found, the backup will stop. Using backup checksums may affect workload and backup throughput. If you want to continue the backup, you have to write CONTINUE_AFTER_ERROR…

  • OpenDataSouce function – to query OLEDB Data Source

    OPENDATASOURCE OpenDataSouce function helps you to get ad hoc connection information as part of a four-part object name as an one time alternative of linked server. You don’t have to specify or create the linked server to query other data sources (i.e. MS Excel, MS Access, MSSQL Older version to newer version etc.) if you…

  • Different options to check object definition

    SP_HELPTEXT system stored procedure is mostly used to check the object definition like definition of a user-defined rule, default, unencrypted Transact-SQL stored procedure, function, trigger, computed column, CHECK constraint, view, or system object such as a system stored procedure. OBJECT_DEFINITION – is BUILT IN function returns the source text of the specified object. It returns…

  • T-SQL Script to check SQL Server Instance TCP/IP Port Number

    SQL Server Error Log Executing DMV Script For Dynamic Port Number — Read the registry for port number For Static Port Number

  • Error Fix: Microsoft SQL Server, Error: 14516

    Problem: Proxy (1) is not allowed for subsystem “SSIS” and user “Domain\UserName”. Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy. (Microsoft SQL Server, Error: 14516) Solution: Above error occurs when the user with the minimum permission (i.e. SQLAgentReaderRole and SQLAgentUserRole) or the user is configured as job owner and trying to run the job which is…

  • T-SQL Script to Check if LiteSpeed is installed or not on the server

    You can execute below script against the SQL Server instance and check whether LiteSpeed is installed on the server or not. T-SQL script is checking registry to check the LiteSpeed version value.

  • Powershell – To check the Drive and Disk Space Information

    To get the disk space details of the server, simply go to command prompt and paste the below script it will give you disk space details. Sample Output Caption : C: Capacity_GB : 283.44 FreeSpace_GB : 51.48 PercentUsed : 81.84 PercentFree : 18.16

  • T-SQL Script to Check the Native Compressed backup file size and Backup Compression Ratio

    First of all make sure backup compression is enabled on the SQL Server. You can execute below query to check the backup compression. Execute below script to check the compressed backup file size and backup compression ratio.

  • Powershell Script to Check – Number of Cores and Logical Processors

    Execute the below powershell script to get the number of cores and logical processors on the server. You can even check all the processor values from win32_Processor class.

  • SQL Server – Backup Verification Script – Based on conditions

    Problem: There are scenarios where you have to verify the multiple SQL Server instances backup within limited time frame whether it meet your organization backup criteria standards or not. Solution: You can execute below T-SQL script to check the backup status as per your organization standard by assigning backup conditions value to backup criteria variable.…

  • RESOURCE_SEMAPHORE WAIT – Performance Troubleshooting

    Recently I was involved in troubleshooting the performance issue. All the queries were running slow on SQL instance. Most of the queries usually complete in seconds and that day it was running more than 15 minutes and not return any output. I have followed below approach to fix this issue. Step 1: Checked for the…

  • How to rerun the SQL Agent job step automatically in case of failure?

    How to rerun the SQL Agent job step automatically in case of failure? Take an example of long running the job with the multiple steps where each steps has dependency of the previous steps successful execution. In case if any of the job step fails, entire job will fail and DBA has to manually run…

  • What is the role of job owner in SQL Server? How does it affect job?

    role of job owner account When SQL Server Agent run the schedule job it will check for the permission of the job owner, if job owner is non-sysadmin account, SQL Server logs into job using its own credential and switches the context of the job to non-sysadmin job owner account. You can see the job…

  • Script to check SQL Case Sensitivity

    You can execute below script to check whether SQL Server is case sensitive or not

  • Spinlocks lightweight synchronization primitives

    Spinlocks are lightweight synchronization primitives which are used to protect access to data structures. Spinlocks are used to access data structures for a very short period of time. When a thread attempting to acquire a spinlock and if it is unable to obtain access it executes in a loop periodically checking to determine if the…

  • Script to get data file size, used space and free space

    While troubleshooting the disk space issue, you can use below script to check the data file size, used space and free size.

  • Best Practices SQL Server Transaction Log

    Background In SQL Server Database Recovery model will decide how the transaction log will be logged in transaction log file. Transaction log file extension is .LDF Full – Transaction log is fully logged (Can take log backup) Bulk Logged – Bulk transaction is minimally logged (Can take log backup) Simple – Transaction log will be…

  • Task Scheduler Error – specified logon session does not exist

    Recently I got a task to move windows server 2003 to windows server 2008. Task is designed to execute .CMD file which internally calling .BAT file. Task was designed to run using service account with store password on windows server 2003. First of all I was unable to import the task to windows server 2008…

  • Stripping SQL Server Database Backup to Multiple Files

    Stripping Database backup to multiple files and on different drives will make the backup speed faster and will reduce the backup duration. Check the below sample script for the backup and restore. You can perform the same task using SSMS GUI as well. Backup Script Restore Script

  • Script to find out the traces running on SQL Server instance

    You can execute the below script on SQL Server instance to find out the traces, trace type, trace file path and trace status.

  • Script to get the SQL Server Installation Date and Authentication Mode

    Recently I got a request where I have to check the SQL Server installation date and SQL Server authentication mode. I have write the below script and execute it against all the servers registered in CMS. Here is the script

  • Wish You All Very Happy New Year 2014

  • How to attach a SQL Server database with a missing transaction log file?

    There may be situation where the transaction log file is corrupted or delete due to some issue, there is still hope to recover the database using data file. In the below script we will create the scenario and recover the database using data file only.

  • LiteSpeed – Restore Script

    Script to check the backup file – data and log file information Script to check the backup file header information Script to verify the backup file if the backup file is valid or not Script to restore database using Full backup with the default options Script to restore database using Full backup with file move…

  • LiteSpeed – Backup Scripts

    full or complete database backup differential backup transaction log backup filegroup backup

  • Table Hints – NoLock vs ReadPast

    When any data in a database is read or modified, the database engine uses special type of mechanism, called locks, to maintain integrity in the database. Locks will be used to make sure the transaction consistency. NoLock Table Hint – Will allow you to read the uncommited data – Only used with SELECT statement –…

  • XP_LogEvent and RaiseError

    xp_logevent xp_logevent extended stored procedure is used to log the message into the SQL Server error log and event viewer application log. Syntax xp_logevent { error_number , ‘message’ } [ , ‘severity’ ] Parameter Description Error number Error number should be greater than 50000 Message Text you want to record in the error log and…

  • How to find out the SQL Server installation date?

    Problem How to find out the SQL Server installation date? Solution: To get the exact SQL Server installation date we have to check for the object which is created at the time of installation. NT Authority\System login is getting created at the time of SQL Server installation. You can check the SQL Server installation date…

  • How to make sure that view metadata is updated?

    Problem: How to make sure that view metadata is updated? Solution: You can use sp_refreshview system stored procedure to make sure that view meta data is updated. See below example for more information. You can create below procedure to refresh all the views on the database.

  • How to connect SQL Server instance in case of SSPI context error?

    In case of SPN (Service Principle Name) registration failed and you are getting the SSPI context error while connecting to SQL Server instanc you can use the Named Pipes protocol if enabled. To connect SQL Server instance using named pipes protocol you have to write NP against the instance name. See below image for more…

  • How to install IIS on Windows 7?

    IIS is mandatory for the Virtual Server installation, in this article I will guide you how you can install the IIS on windows 7 or windows vista.   Step 1: click Start, and then click Control Panel     Step 2: In the Control Panel, click Programs then Click Turn Windows features on or off and from…

  • What is “Null”? How much space “Null” value takes in SQL Server?

    Null is neither zero nor empty string. Null is not a value at all. Most importantly for our discussion, one null value does not equal any other null value. In the RDBMS, Null simply means a value that is not known. NULL value can occupy in the database based on the coulumn data type and…

  • Script to find out Stored Procedures which are Using most resources

    While doing the stored procedure performance tuning, you can use sys.dm_exec_procedure_stats DMV to get resource intensive procedures. You can use the below script for it.

  • SQL Server 2014 – Public CTP Now Available

    You can download SQL Server 2014 CTP version from – http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx You can get the more information on SQL Server 2014 from http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/25/sql-server-2014-public-ctp-now-available.aspx link SQL Server 2014 only support x64 bit architecture.

  • SQL Server 2008: SQL Mail does not work with the 64-bit version of SQL Server (Microsoft SQL Server, Error: 17938)

    Recently I got email from one of the blog reader that he is getting below error while setting up SQL MAIL as legacy feature in SQL Server 2008. Error: SQL Mail does not work with the 64-bit version of SQL Server (Microsoft SQL Server, Error: 17938) Solution: SQL Mail is not supported on 64-bit versions…

  • T-SQL Script to find out the database file size, space used and available free space

    While troubleshooting disk space issue, it is essential to know about the database file size statistics. You can execute below script to get database file size information.

  • How to make Lite Speed Central database and Local repository in sync?

    If you have configured the LiteSpeed in your environment using the Lite Speed Central repository option, there will be a scenario when Lite Speed Central repository misses some data. To make the data available in central repository you can use the LiteSpeed local database and execute the below procedure to ensure that cenral repository comes…

  • Permission required for SP_UpdateStats

    To update the statistics on the database you should either be DBO of that database or SysAdmin on SQL instance. If you want to grant the least permission instead of server level permission you make the user DBO of the database. You can do it from database properties windows as below. You can also make…

  • ORIGINAL_LOGIN() and SUSER_SNAME() functions

    ORIGINAL_LOGIN() function returns the name of the original login that connected to the instance of SQL Server and is used to identify original login in all sessions. Even though you will do the security context switch it will return the original login name. SUSER_SNAME returns the name of user in the current security context. Check…

  • Script to get the Last Backup Date of database full and t-log backup

    To get the max backup date of the database or to check whether database is backed up or not. You can execute below script to check the last backup date.

  • Script to get the database backup history

    For the point time recovery or in case of failure it is essential that you should have the backup history of the database. You can execute the below query against the database to get the backup history.

  • Important Trace Flags for DBA

    A trace flag is used to set specific server characteristics or to switch off a particular behavior of the SQL Server. You can enable the trace flag from Startup Parameters, Session and Global Session level. Trace Flag 610 : Minimally logged DML operations into Indexed tables, transaction log and allow bulk loading Trace Flag 4199…

  • How to monitor SQL Server Services of multiple instances?

    Problem: I have a need to monitor the SQL Server Services in my environment. Are there any programmatic options to do so? Check out this tip to learn more. Solution: http://www.mssqltips.com/sqlservertip/2867/steps-to-monitor-the-sql-server-services/

  • Get the List Of DBCC Commands & Syntax

    If you don’t remember all the DBCC commands “NO Issue” execute the DBCC HELP command to get the list of all the DBCC. checkalloc checkcatalog checkconstraints checkdb checkfilegroup checkident checktable cleantable dbreindex dropcleanbuffers free freeproccache freesessioncache freesystemcache help indexdefrag inputbuffer opentran outputbuffer pintable proccache show_statistics showcontig shrinkdatabase shrinkfile sqlperf traceoff traceon tracestatus unpintable updateusage useroptions…

  • Script to get the SQL Agent Properties

    You can use the sp_get_sqlagent_properties undocumented stored procedure to retrieve the SQL Agent properties of a SQL Instance. It is available in SQL Server MSDB database. This procedure only works if the SQL Agetn Service is started.

  • sys.dm_server_registry

    sys.dm_server_registry DMV gives information about installation and configuration data that is stored in the windows registry for the current instance of SQL server. You can use to check the start up parameters, protocols, error log configuration, agent log configuration and IP Addresses.

  • Happy New Year – 2013

    Wish you & your family very happy & prosperous new year 2013.

  • Steps to Move SQL Server Log Shipping Secondary Database Files

    Problem With SQL Server is it possible to move the secondary database involved with Log Shipping to a different drive without disturbing the Log Shipping configuration? If so, what are the steps to accomplish this task? Check out this tip to learn more. Solution http://www.mssqltips.com/sqlservertip/2836/steps-to-move-sql-server-log-shipping-secondary-database-files/

  • sys.dm_server_services

    sys.dm_server_services DMV is available in SQL Server 2008 R2 SP1 and SQL Server 2012. It will return the information about the below SQL Services on the current instance. SQL Server (2008 R2 SP1 and SQL Server 2012) SQL Server Agent services(2008 R2 SP1 and SQL Server 2012) Full-Text(SQL Server 2012)

  • Powershell Script to get the Operating System Infomrmation

    You can use the Win32_OperatingSystem class to get the Operating system info.

  • Logical function – Choose – SQL Server 2012

    CHOOSE function is the logical function. It is similar to SWITCH function in .NET. Choose function will return the item at the specified index from the list of values .

  • Link to download Sample SQL Server Databsae