Orlando PASS User Group Presentation
I presented a one-hour session for Orlando PASS User Group on Powershell and SQL Server. I had previously given this talk...
2009-07-12
619 reads
I presented a one-hour session for Orlando PASS User Group on Powershell and SQL Server. I had previously given this talk...
2009-07-12
619 reads
Richard MacDonald's demonstrates using Microsoft Chart Controls with Powershell in his post, Charting with Powershell. The chart controls are free and work with...
2009-07-09
3,313 reads
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,133 reads
I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions,...
2009-06-28
1,605 reads
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,654 reads
In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with...
2009-06-19
1,465 reads
Co-worker and fellow DBA,, John O'Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out...
2009-06-17
1,047 reads
Tim Benninghof tagged me with the question. "So You’re On A Deserted Island With WiFi and you’re still on the...
2009-06-13
444 reads
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,321 reads
2008-09-11
415 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers