Powershell Tips–Showwindow
Looking for help is a pain in Powershell. I type something like
help get-process
execute this and I’m scrolling up and down....
2014-07-21
1,159 reads
Blog Posts
Rename SharePoint Central Administration Database
SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that...
2014-07-21
1,444 reads
Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step...
2014-07-21
4 reads
Tampa Code Camp Revivial
If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you...
2014-07-21
746 reads
Victims of Success
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
670 reads
Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)
Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Segment Elimination for Deleted Row Groups
After some very interesting and inspiring conversations...
2014-07-20
552 reads
Extraordinary #2
This is another situation that happened on a database migration at a client site. The database migration was done by using SSIS...
2014-07-19
107 reads
Things You Can Find in the Plan Cache at SQLBits
On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to...
2014-07-19
443 reads
Database jokes
Sometimes when work is tough you just need to take your eyes and mind away from your working console. Jokes are...
2014-07-18
6,227 reads
Database jokes
Sometimes when work is tough you simply need to take your eyes and mind away from your working console. Jokes are one...
2014-07-18
1,303 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers