Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Make a thoughtful gift as a surprise for someone

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

When Is Technology Good Enough?

I just paid off my mobile phone. In my case, this is a phone from Google Fi, which provides fantastic service for me. The phone works well in any country I travel to, without any extra roaming costs outside the US for data. That works well, since it's a data device, and not really a voice device for me. Even overseas, lots of my calls are through some data service, like Facebook Messenger.

The decision for me now is whether to upgrade my phone. I've been getting some promotions and I've seen some deals from other retail outlets on phones, so I've been considering changing my Galaxy S20 for an S22 (perhaps plus) or a Pixel 6. There have been some improvements in cameras, and those are really the only change I'd notice.

Mobile devices have mostly become a commodity for me. The screen is a certain size, and the camera has a quality level, but outside of this, I don't know that I've noticed much of a change in how I use the device or what I notice in quite a few years. If the screen and camera are the same, one phone is fairly interchangeable with another. Even the battery doesn't seem to change that much between phones.

I think the same thing is true for databases for many of us. A lot of applications, and even developer T-SQL, target the basics of what a relational database platform provides. I suspect most of our needs could be served by MySQL or PostgreSQL as well as SQL Server. Apart from changing the dialect of DDL and DML we write, all those systems work well. In fact, I suspect most of what is run against the SQL Servers backing SQL Server Central could work against an older version such as 2005 or perhaps even 2000.

Some of you use newer features. Plenty of people have learned to use Window functions and the OVER() clause. Some of you might use In-memory tables. Others certainly need Availability Groups. However, a majority of code I see uses nothing newer than a CTE, which means they could run in SQL Server 2005.

A new version of SQL Server is coming later this year. SQL Server 2022 is in preview, and there are some neat things in there. Do you need them for your application? Perhaps you could use them, but the better question is will you actually change how you write code to use the new features? Or change how you set up infrastructure? I'd hope that many of you would, but change is hard for humans, and developers struggle as much as others. We get stuck in our habits and tend to work as we have for years.

When is the technology platform, tool, service, or application you use "good enough" for most of your work? I don't know, but I find myself less excited about newer tech in many cases. Perhaps because I'm old, or perhaps because my needs are relatively simple. Is that the case for your organization?

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

Tips to improve Power BI report appeal

Daniel Calbimonte from SQLServerCentral

This article will show you how to use a Powerpoint theme to modify and beautify a Power BI report.

External Article

Database DevOps: Standardize, Automate, Monitor & Protect

Additional Articles from Redgate

See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.

External Article

Metrics that matter for IT organizations on an agile journey

Additional Articles from SimpleTalk

Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.

Blog Post

From the SQL Server Central Blogs - Extended Events for Anything but Query Tuning: Object Changes

Grant Fritchey from The Scary DBA

I hear this one all the time: How do I find out who implemented object changes? I also get: Can I see the query that caused object changes? Let’s...

From the SQL Server Central Blogs - Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source

Rayis Imayev from Data Adventures

(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets, building your data model and enriching it with interactive and engaging visualizations. Now you are...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Using CONTINUE

When do you use CONTINUE in T-SQL?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Cleaning Tables

What does DBCC CLEANTABLE do?

Answer: This reclaims space from dropped variable length columns

Explanation: This command will reclaim space from dropped variable length columns only. Ref: DBCC CLEANTABLE - https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-cleantable-transact-sql?view=sql-server-ver16

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
SSAS Views - Hi, When I connected to SSAS in Management studio, I can able to see 2 databases there. The each database has one cube which is same name as the database name. When I selected datasource connection string for one cube it is pointing to the local connection.  When I connect to the SQL Database Engine […]
SQL Server 2017 - Development
Turning Col into Multiple Rows - Hello, I am interested in turning one column into multiple rows depending on the value.  I tried a pivot but seem to be doing something wrong.  Here is some sample code with desired results following:   -- DROP TABLE #t CREATE TABLE #t (ID int IDENTITY(1,1), CoID int, CoName varchar(100), Class varchar(100)) INSERT INTO #t […]
Select * (-----) - Hi, I have a problem like below one. Give, for each train station, the number of distinct (other) train stations that can be reached directly (so without using multiple trips) within one hour of travelling (i.e. the time difference between departure in one station and arrival in the other is 60 minutes or less) and […]
SQL Server 2016 - Administration
TDE master key password change - Hello I have a requirement to change the TDE master key password in one of the environments. Do I need to redo the whole process (encrypt the dbs with the new master key password) again after I regenerate the master key password?   Kindly advice
SQL Server 2016 - Development and T-SQL
calculation for year month and quarter with date dimension table - i want to know how i can use the date dimension table. I am trying to sum all my sales for month, quarter and Year with joining a date dimension table but not sure how to go about that can you assist or direct me to a good resource? I have a query but i […]
Query help - Here is the DDL of the table: I need single row per invoicenumber and line and rest of the amount and comments should to go to additional columns  in the same row as shown (in the spreadsheet). What would be the best way to accomplish this? DROP TABLE IF EXISTS #temp1 CREATE TABLE #temp1 (Program […]
Administration - SQL Server 2014
Get ID from Analysis Server cube. - I am fixing an issue with our automated Analysis Server backups. We use SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS to get the catalog name, and then plug that into our t-sql to do a backup. The script puts the catalog name into the DatabaseID XML for the backup. The issue is, for some of the cubes, the […]
Development - SQL Server 2014
Cancel query and transactions - I open a new query window in SSMS and execute: EXEC stored procedure. The stored procedure contains BEGIN TRAN and COMMIT / ROLLBACK TRAN. I hit the cancel button and get told it has been done, almost instantaneously.  When I then close the query window, I get the message: "There are uncommitted transactions. Do you […]
SQL Server 2019 - Administration
Backup probleme with SQl Server Writer - folder offline - Hi, I use a tool to backup mysq MSSQL database with Writer SQL SERVER VSS. A database for a database not work because it's excluded from VSS Writer... Here the log of SQL Server Writer : [08/17/2022 16:21:58, TID 17d8] Skipping database SYNCHRONIZOR on instance SRV-SQLSERVER because file C:\NTNX\ERA_DATABASES\SYNCHRONIZOR\DATA1\data\SYNCHRONIZOR is offline. [08/17/2022 16:21:58, TID 17d8] […]
Database and logs partitions filling like crazy - Hello, I've got some strange behaviour lately with my sql server. Actualy there are 2 servers with all the DBs in an AOAG. Both partitions (one for DBs and one for LOGs) are showing up as almost filled, but when I check the actual files on the disk the size of the files is quite […]
SQL Server 2019 - Development
Select statement results - Hi, I am trying to get result when only C drive is less than 10% and other drives less than 20% but exclude server vc5 for e,g,h,i drives - "SERVER='VC5' and drive not in ('e','g','h','i')".   drop table tbl_test go create table tbl_test (Server varchar(200),DRIVE varchar(200),FREE_SPACE_IN_MB int, used_SPACE_IN_MBint, Total_SPACE_IN_MBint, Precentage_free int ) insert into tbl_test […]
Cannot set a value when initializing a variable - The strangest thing happened. I want to make a change in a stored procedure that I have used for ages. All of a sudden I get errors when trying to alter the sp. It turns out that the culprit is the following line: DECLARE @PermissiesViaGroep bit = 0 When I change it to the code […]
Reporting Services
Image within a Rectangle - I am being asked to overlay text objects to a government form for a client. Unfortunately, I am having massive issues with the image not re-sizing to fit the standard 8x11 paper size, it's way too big. Has anyone had such luck with resizing an image down or has code to help with this? Any […]
General
Introduction about me - Hello all, I'm a bachelor's Student. Now, I've decided to put my articles on my own website. At my university, I'm already working on php. But I think I'll use WordPress to make my site because it's easy. So, I got to work on it and set up SQL server, but I ran into a […]
Integration Services
Error when running SSIS package after deploying - Hi everyone, So I have designed a SSIS package in which I am using Zappysys Excel Destination: https://zappysys.com/products/ssis-powerpack/ssis-excel-file-destination/ I am using this to transfer my SQL table data in to excel file. When I run this SSIS package from Visual Studio, it runs fine and give me the excel files I need. But when I am […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -