Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.
Can SQL Server scale? Phil Factor has a few thoughts on the capacities that SQL Server can scale to.
Dattatrey Sindol shares his tips and tricks on SQL Server Reporting Services Report Manager. He provides guidance on Customizing Report Manager Header/Title, Uploading Custom File Types to Report Manager, and Enable My Reports Feature.
Problems with blocking processes can be easy to identify with SQL Server DMV's.
We have so many ways in which we can grow our SQL Server careers. Steve Jones shares a few today.
MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.
A Dominoes game of Texas 42 inspires Joe Celko to explore unusual uses for check constraints and views. Sometimes, the best way of discovering useful SQL techniques is to tackle the more unusual problems.
Are you worried about your job in the future? Steve Jones thinks you shouldn't be.
Join us at SQL Saturday Denver on September 28. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This SQL Saturday includes a number of options for pre-conference training in Denver, including a free session presented by Steve Jones.
SQL Server Central Webinar #25: Best Practices in Database Deployment (Part 1)
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Comments posted to this topic are about the item TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers