Introducing PowerShell V2 Remoting for SQL Server
owerShell can be used to for many SQL administrative tasks; this tip walks through how to run T-SQL code and admin tasks on remote servers.
A Matter of Life or Death
Could your job as a data professional result in the death of someone? It's entirely possible this might affect you at some point. Steve Jones talks about why you ought to do your best when setting up security.
Are remote databases fragmented? Let's Defrag.
This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.
Now you ODBC me now you don't
Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.
Disk Space Monitoring and Early Warning with PowerShell
Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.
Stairway to MDX - Level 6: Member “Family” Functions: .Parent and .Children
Some of the most important 'Member' functions of MDX are often known as the 'Family Functions'. These are used in queries on multidimensional structures for analysis and reporting, and can refer to relative nodes in the hierarchy in much the same way as in a family tree.
The Apprentice
This Friday Steve Jones asks if we should reconsider the way we train developers and other computer professionals. Give us your opinion this week.
The SQL Server Query Optimizer
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.
Find which port SQL Server is using to establish connections
This article will show you how to determine which network port that SQL Server is listening on for connections
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers