2021-03-30
471 reads
Tools for development
Tool Limits
Today Steve asks about the tools you use for your job and if they help or hurt your productivity.
2021-03-19
209 reads
Your Favorite IDE
SSMS is, well, it's what we mostly have from Microsoft. It's been around a long time, but it is getting regularly released. There are new versions about every quarter, and there are bug fixes and minor enhancements. Azure Data Studio appears to be where Microsoft would like most of us to move, but I, and […]
2020-12-04
362 reads
The Separation of Tools
SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.
2020-11-02
586 reads
Other IDEs
This editorial was originally published on Jun 17, 2020. It is being republished as Steve is out of town. Let us know if you've changed your SQL IDEs since then. Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us […]
2026-05-11 (first published: 2020-06-17)
875 reads
Microsoft SQL Server Utilities and Tools
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities
2020-06-02 (first published: 2020-05-26)
39,411 reads
Using the Lightweight Tools
This week Steve is interested in whether the newer lightweight environments, like VS Code and Azure Data Studio, are capturing your interest.
2023-06-12 (first published: 2019-12-19)
887 reads
Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
2019-12-07
337 reads
2019-11-18
1,272 reads
SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip
My most of the Comprehensive Database Performance ...
2019-05-23
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
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
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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