Back up Encryption
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we...
2018-09-11 (first published: 2018-09-05)
2,122 reads
Moving an Azure SQL Database across Resource Groups
In my mind there are a couple of ways to move a database across resource groups. They vary from scripting...
2018-09-05
944 reads
Podcast Audio Now On SoundCloud
For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...
2018-09-05
309 reads
Apache Hadoop Release 3.1.1 available
Last month Apache Hadoop also release its latest Stable release version Apache Hadoop 3.1.1 which has major improvement in Hadoop system....
2018-09-05
415 reads
I will be speaking @ SQLSaturday 795 Porto
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
16 reads
I will be speaking @ SQLSaturday #795 Porto
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
12 reads
Getting started with SQL Server Tools
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-09-04
653 reads
Why Separate Your Compute From Your Storage
There are many advantages to using Microsoft Azure. One big reason people look at Azure is the ability to separate...
2018-09-04
424 reads
Watch SQL in the City Streamed September 2018
I’m over in the UK and we have SQL in the City Streamed tomorrow. This is our September edition, and...
2018-09-04
252 reads
Did Not Know That - Redirecting CMD to the Clipboard
One of the items I frequently deal with as a Production DBA is drive alarms. I have written previously about...
2018-09-12 (first published: 2018-09-04)
2,886 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