SQL Server Powershell Extensions PowerGUI PowerPack
If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is...
2009-07-24
1,177 reads
Chad Miller
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
628 reads
Powershell Charting with MS Chart Controls
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,493 reads
Powershell SQL Server Backup/Restore
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,159 reads
SQLPSX Release 1.6
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,622 reads
Powershell + SMO Error Handling Tips
Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO...
2009-06-25
1,683 reads
Adventures in Powershell SSIS Administration Programming
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,568 reads
Creating Red Gate SQL Compare Snapshots with Powershell
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,070 reads
Give Me a Coconut and Six Months
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
475 reads
Backup Monitoring and Reporting
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
2009-06-04
16,325 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