3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
156 reads
Blog Posts
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...
2017-10-03
17 reads
Always update your views
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
374 reads
Book Review: High Performance SQL Server
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
404 reads
Box-and-whisker plot and data patterns with R and T-SQL
R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been...
2017-10-03 (first published: 2017-09-25)
2,670 reads
Deploy SSAS Cubes With PowerShell
Hello!
Recently someone got in touch with me about one of my earliest posts on my old blog. I realised I...
2017-10-03
1,129 reads
Haunted SQL
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...
2017-10-03
346 reads
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
740 reads
Power BI Custom Visuals Class (Module 70 – Custom Calendar By Akvelon)
In this module you will learn how to use the Custom Calendar by Akvelon. The Custom Calendar by Akvelon is...
2017-10-03 (first published: 2017-09-25)
2,123 reads
Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
18,037 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers