Import export wizard at the commandline
TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...
2014-05-12
1,829 reads
Psst! Wanna some API?
If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...
2014-05-11
702 reads
Data Collection in SQL Server
Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...
2014-05-11
871 reads
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition !
Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit...
2014-05-11
696 reads
That “Cannot Generate SSPI Context” headache
Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally...
2014-05-10
1,524 reads
Allowing your App team to run SQL Agent Jobs
Problem : In most of your projects, there is always that situation that the application team have that need to run...
2014-05-10
674 reads
SSRS #74 – 2008 Cascading bug when you have a middle parameter
Some SSRS reports have a large number of parameters
I recently had a chance to help a co-worker to modify...
2014-05-09
1,769 reads
Quick Snapshot
The idea for this script came at times when I was having a project that needed to use snapshots of databases...
2014-05-09
108 reads
Script for database snapshot
The idea for this script came at a time when I was having a project that needed to use snapshots...
2014-05-09
115 reads
Reblog: May 2 to May 8
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-05-09
938 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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