What is a Foreign Key & How many foreign keys can you have on a single table?
Yesterday, I was attending a database design meeting. In the meeting, I was asked one of the questions – “How many...
2018-04-12 (first published: 2018-04-05)
12,148 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
166 reads
Farewell, Robert Davis
Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering...
2018-04-13 (first published: 2018-04-04)
3,144 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-04
133 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-04
142 reads
Why didn't my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-09 (first published: 2018-04-04)
1,667 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn't have any debugging information enabled...
2018-04-04
22 reads
Encrypting SQL Server Database Backups
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,504 reads
Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018
I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two...
2018-04-04
293 reads
Toolbox - Do You Have Current Backups?
On our managed servers we run a job each day to check that either a FULL or DIFF has run...
2018-04-04
689 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