Azure means hybrid now
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
381 reads
Azure Cognitive Services – Language APIs
In today’s post focusing on Azure Cognitive Analytics, I’ll look at the Language Analytics APIs that are available. These language...
2018-09-26
352 reads
I’m Giving Four Free Sessions in October!
I’ve got FOUR sessions coming up in October. These sessions will each be 30 minutes. Redgate Sessions Wed, Oct 3, 9AM PT / 12PM ET: How to Lead DBAs...
2018-09-26
28 reads
Azure Database Migration Service (DMS)
As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that makes it easy to migrate from on-prem/RDS to Azure...
2018-09-26
50 reads
Azure Database Migration Service (DMS)
As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that...
2018-10-08 (first published: 2018-09-26)
2,761 reads
sqlhelp: limit the x-axis of a geometry line graph
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
385 reads
No More Mysterious Truncation
If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions...
2018-10-09 (first published: 2018-09-26)
3,375 reads
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the email was “Tech edit a book” and he...
2018-09-26
20 reads
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity
Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the...
2018-09-26
287 reads
Data Types Word Search
Just for fun here is a word search with all of the data types available in SQL Server. Well, two...
2018-10-05 (first published: 2018-09-26)
1,843 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