PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
1,282 reads
Blog Posts
Preparing for SQLSaturday #49
We’re still in the early stages so the pace is comfortably slow. We’ve got about 30 sessions in already (plenty...
2010-05-20
518 reads
SQL Server MasterClass – London
Further to my post on May 18th regarding the above event – I have been able to secure a further £50...
2010-05-20
527 reads
Using PATINDEX to Split Column Data
A colleague of mine received an Excel file that he needed to load into a table for future lookup values....
2010-05-20
1,183 reads
What 5 things should SQL Server get rid of?
Paul Randal (Blog|Twitter) recently kicked off this meme by listing the 5 things he thinks SQL Server should get rid of....
2010-05-20
929 reads
Daily SQL Server 2008 New Feature – Day 10
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-19
668 reads
It’s a Data World
I saw this blog about a report from CITA (wireless industry group) that people tend to use their cell phones...
2010-05-19
673 reads
June OPASS Meeting Date Change
Andy Warren (@sqlandy) already blogged about the change here, but I there might actually be someone who reads my blog...
2010-05-19
266 reads
oPASS June 2010 Meeting Date Change
Normally we meet on the second Tuesday of the month, but in June we’re going to have to push the...
2010-05-19
567 reads
PowerShell Week at SQL University – Post 2
Cmdlets, Functions and Snapins
So far we’ve learned how to open up PowerShell and add on to it with some modules;...
2010-05-19
1,068 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers