Finding lost or forgotten SQL Servers
This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.
2013-07-25 (first published: 2011-04-19)
15,710 reads
PowerShell
PowerShell Basics
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
2013-02-22 (first published: 2011-01-24)
25,149 reads
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
874 reads
PowerShell Version 2: What is new and why is it important?
It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work
2010-10-01
4,489 reads
Moving Indexes with Powershell and SMO
Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.
2010-09-30
4,697 reads
Gathering Perfmon Data with Powershell
Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.
2010-07-21
3,220 reads
I’m a SQL Server DBA, and I’m in Love with PowerShell
To learn PowerShell, Laerte Junior suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice, "the lion is dead".
2010-06-24
5,883 reads
Sharing Your Scripts - Made Easy
Windows PowerShell v2 introduces self-contained “modules,” making it easier to share scripts with reusable functions, custom format views or type extensions.
2010-05-28
2,789 reads
Retrieve Default SQL Server Backup Folder using PowerShell
In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?
2010-04-23
2,763 reads
Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation
In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.
2010-02-26
2,552 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers