Steps for SQL DB Geo Replication
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on...
2018-09-26 (first published: 2018-09-14)
2,589 reads
A Quick Intro to DevOps in Azure
Today, I’d like to discuss DevOps in Azure and tell you why you should consider using DevOps when you start...
2018-09-14
957 reads
Them Con+cat+enatin’ Blues
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...
2018-09-24 (first published: 2018-09-13)
3,226 reads
Customer Roadblocks to Azure
When I speak with customers, I often find they share common roadblocks to using Azure. I recently sat down with...
2018-09-13
734 reads
SQL Server string functions for Data Munging (Wrangling)
In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server....
2018-09-13
369 reads
Using Table Valued Parameters with sp_executesql
Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to...
2018-09-24 (first published: 2018-09-13)
3,953 reads
The real differences between Dynamics 365 Operations Embedded Power BI and BYOD Power BI
I get asked this question all the time in my work as I am the BI consultant in Dynamics 365...
2018-09-25 (first published: 2018-09-12)
2,096 reads
Importing Flat Files in SSMS 17.x Works
One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis....
2018-09-21 (first published: 2018-09-12)
2,320 reads
Azure Storage – Hot, Cold, Archive
There’s a lot of talk about storage options. When working with customers, I often introduce them to Azure through storage,...
2018-09-12
733 reads
Bulk insert issue with UTF-8 fixed-width file format
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
307 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
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