Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,756 reads
Blog Posts
Yet Another Facebook Page - Living For SQL Server
I have created facebook page named "Living For SQL Serever" couple of days back.
https://www.facebook.com/LivingForSqlServer
Inviting our community friends to like this...
2012-09-28
1,804 reads
An Introduction to SQL Server
There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...
2012-09-27
812 reads
Cannot assign a default value to a local variable !
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,934 reads
DBA Manager Needed in Orlando–Putting My Network to Work!
I”m working with a client in Orlando that needs a manager for their data team, seems like a prime opportunity...
2012-09-27
1,548 reads
Full Text Search – CONTAINS
I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators....
2012-09-27
4,831 reads
MDS Error: “The status of the specified batch is not valid”
In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch...
2012-09-27
2,375 reads
Nested Partitioned Views
A few weeks ago I had a customer engagement, where the customer wanted to implement
Nested Partitioned Views. Before we go...
2012-09-27
3,015 reads
Nested Partitioned Views
A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we...
2012-09-27
936 reads
No more NebraSQL
After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?) I have...
2012-09-27
769 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
BCA KCU WISMA MILLENIA Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec....
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers