Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
4,704 reads
Blog Posts
The 700 Milestone for SQL Saturday
This past weekend was SQL Saturday #700. Another milestone in the franchise of events, and I was glad to attend....
2018-03-26
763 reads
2018-03-25
34 reads
Allowing Azure Service to Connect to your Azure SQL server.
Allowing Azure Service to Connect to your Azure SQL server.
In this video David will look at the impact of allowing...
2018-03-23 (first published: 2018-03-13)
1,720 reads
Community
Community.
In the SQL Server community, we are basically one big #sqlfamily. This is a story of how the family helped...
2018-03-23
413 reads
Power BI Custom Visuals Class (Module 95 – VitaraCharts–MicroChart)
In this module you will learn how to use the VitaraCharts – MicroChart. The VitaraCharts – MicroChart provides a intuitive way to...
2018-03-23
1,050 reads
Scripting Tables with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-03-23
1,632 reads
SQL Saturday #695 Guatemala
This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...
2018-03-23
118 reads
SQLSaturday Madison – “Data Security for the Cloud” and “Three Steps to Lasting Encryption”
In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...
2018-03-23
237 reads
T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026
Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...
2018-03-23 (first published: 2018-03-13)
2,500 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