Powershell Day 20
Day 20 Introduction to SMO >>SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server...
2011-04-20
429 reads
Vinay Thakur
Powershell Day 19
Day 19 Sql Server with .Net Using .Net programming is we can connect to sql server, its similar with any...
2011-04-19
553 reads
Powershell Day 18
Day 18 PSSnapin Powershell works with cmdlets, and cmdlets are commands from snapins. Means spanin contains group of commands. so...
2011-04-18
820 reads
Powershell Day 17
Day 17 Advance Mini Shell Mini shell is a good and can be used as a replacement of management studio,...
2011-04-17
420 reads
Powershell Day 16
Day 16 Introduction to Mini Shell Mini Shell or SqlPS is the default shell utility provided by Microsoft to support...
2011-04-16
400 reads
Powershell Day 15
Day 15 Introduction to Powershell for MS Sql Server So far we have discussed several features and information about Windows...
2011-04-15
785 reads
Powershell Day 14
Day 14 Tools and more info As Powershell is a global language and its open to explore. So many great...
2011-04-14
570 reads
Powershell Day 13
Day 13 Other XML: Powershell support XML, as XML is a language which works great for windows, and it’s like...
2011-04-13
683 reads
Powershell Day 12
Day 12 ADSI Using Powershell you can work on Active directory as well. Active directory is introduced in windows 2000....
2011-04-12
483 reads
Powershell Day 11
Day 11 COM and WMI Powershell is a very powerful language, with Powershell we can achieve same result with the...
2011-04-11
922 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers