Powershell Day 5
Day 5 Programming in Powershell Part 3 Now as you know all information, in this blog we will look for...
2011-04-05
341 reads
Vinay Thakur
Powershell Day 4
Day 4 Programming in Powershell Part 2 Now we got some basic information about shell programming operators and other stuff....
2011-04-04
440 reads
Powershell Day 3
Day 3 Programming in Powershell Part 1 Now you got some good basic information about Powershell, and some basic commands...
2011-04-03
1,092 reads
Powershell day 2
Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...
2011-04-02
1,468 reads
Powershell Day 1
Day 1 Introduction to Powershell I got inspired by great people like Paul Randal and Glenn Berry and decided to...
2011-04-01
817 reads
Torn page detection vs Page Checksum
TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The...
2011-03-28
903 reads
Diskpart command line utility
To get the disk information internal. there is a utility called diskpart this is good utilityto understand your disk information....
2011-03-21
454 reads
Resource database
Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server...
2011-03-04
1,041 reads
Happy New Year 2011
Wish you all a very happy an prosperous New Year 2011. When I see back year 2010 : >> was started my...
2011-01-03
439 reads
NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,502 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers