One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.
A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.
So many of the problems that organisations have with their IT applications are due to the struggle with data, in the absence of overall organization-wide control and supervision of data and its progress through the various parts of the organization. Master data management (MDM) offers a solution to the many data woes by controlling data change, It does it in an analogous way to Version Control, so that changes are cleansed, checked, tracked and audited, and any named version can be published to other services. Now Microsoft has an implementation as part of the data platform.
Learn how to use the login commands included with SSMS2016 from PowerShell.
Finding a balance between work and life away from work is hard, but one good way is with periodic vacations. Today Steve Jones notes that some people don't take their vacation, which he sees as a problem.
When writing T-SQL code, we often write code to check if the database object exists first and then take some action. In this tip John Miner covers the new and easier way to do this in SQL Server 2016.
With the introduction of temporal table support in SQL Server 2016 Microsoft also added some additional functionality that makes it easy for you to join the current and history records of a system-versioned table. Greg Larsen shows you some of the different ways to do analysis of your system-versioned records over time.
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers