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

50 Years of Microsoft

I get the Gates Notes email periodically and I always find it interesting to read. Like Bill Gates or not, he is a very smart individual and has thoughtful things to say. Even when I don't always agree with him, I enjoy hearing his view and have enjoyed seeing him deliver presentations. In fact, one of my career highlights was at SQL Saturday #175 - Fargo, held at the MS campus. Bill Gates was speaking to employees that day and we were allowed to watch the Q&A from the balcony. Later, I saw him start to leave and stop by a sign. He asked someone about SQL Saturday. When they explained the idea for free conferences, he said "that's cool."

One of the recent emails talked about the 50th anniversary of Microsoft, with the original source code available for a BASIC interpreter. It's an interesting read to me, since I learned BASIC first (and a little assembler) on an Apple II and a TRS-80. I didn't start a company, but I certainly appreciate the excitement of tackling a programming challenge back then when memory and disk were in short supply. Most of my early programming tasks had me worried about how much memory and disk I was using, trying desperately to minimize both.

My first real exposure to Microsoft technology came after college, while working at a power utility. We had DOS desktops and were just starting to look at Windows 3.1. Until that point, I'd mostly lived in the Apple II space and then the mainframe/Unix space. I coveted a SparcStation with SunOS and had to settle for a PC architecture because my newly graduated budget wouldn't support anything from SUN.

I adapted to DOS and grew to enjoy the challenges of early Windows. I adopted Win95, learned SQL Server (OS/2 and Windows NT) and the rest is history for me. I've been using Microsoft technologies for 33 years now, and I've enjoyed the time using those tools. I also appreciate the great career that Microsoft gave me.

Looking back at the times I had to work with autoexec.bat and config.sys files, when I used the probe account in early SQL Servers to check configurations, learning to track and read disk configurations for SQL Server 6.5 restores, moving from Windows NT 3.1 to 4.0 to the more modern architectures of Windows 2000 and beyond. Watching the "Visual" series of development tools and the Win32 API evolve into the .NET namespaces and the introduction of PowerShell to give us an easier way of working with non-compiled scripts. These are fun memories for me to look back on.

Most of you reading this likely use some sort of Microsoft technology. What good (or bad) memories do you have?

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Retrieving Data Using the REST API in Data API Builder

Steve Jones - SSC Editor from SQLServerCentral

I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this product works and how to start using it. That was a basic look, but it gives data professionals an idea of how this might help them work more closely with front-end developers who are more comfortable with […]

External Article

Managed Instance Gotchas – Error Conditions

Additional Articles from SimpleTalk

I was recently on a project to migrate a very transactional installation of SQL Server to Azure SQL Managed Instance (MI). SQL Managed Instance is a good stepping stone between a full, on-prem SQL instance / Azure VM and an Azure SQL Database.

Technical Article

Navigating Your Test Data Challenges: Insights and Solutions

Press Release from SQLServerCentral

Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.

Blog Post

From the SQL Server Central Blogs - Building Resilience: Leadership Insights from Sports

Chris Yates from The SQL Professor

In the bustling world of sports, leadership appears as a beacon of hope and direction. Imagine a football team, standing on the brink of a crucial match. The players,...

Blog Post

From the SQL Server Central Blogs - Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

  Question of the Day

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

 

Multiple Collations

Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...

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)

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096

But then deleted the code and couldn't remember. Is there a way to check this?

Answer: use SELECT @@TEXTSIZE

Explanation: @@TEXTSIZE has the value that this setting contains. Ref: @@TEXTSIZE - https://learn.microsoft.com/en-us/sql/t-sql/functions/textsize-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 2016 - Development and T-SQL
Why would using a variable vs Hard Value impact a Query's Performance - Why would using variables in place of hard coded numbers impact a query's performance?  The below code is just an example of what I'm asking. In  my case I have the same query twice with the difference being that one has the values hard coded in the criteria and the other is using variables that […]
SQL Server 2019 - Administration
Size of DB on physical disk doesn't match Disk Usage by Table report - Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS report Disk Usage by Table.  The size of the mdf file on my storage drive is close to 37 GB.  The sum of all tables and indexes (columns Data (KB) + Indexes (KB)) on the […]
SSIS Won't Create Log Entries - Hi everyone My SSIS package will not log to sysssislog.  I am not sure what to do to troubleshoot.  Can someone please provide some guidance on what I can do to help fix this? Setup configuration: The configuration manager I use is the same one I use in SSIS when I have tasks that read […]
SQL Server is terminating in response to a 'stop' request from Service error - Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing in logs except this Message SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. please help to find some solution to fix […]
Somebody realized to configure Cluster-Aware updating on VMWare nodes - Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File server. All servers are VMWare Virtual Servers (with Windows server 2025) Having some problems with configuring the Cluster-Aware Updating. While troubleshooting i was just wondering if this is possible to install. Is there anyone on this forum that was able to […]
SQL Server - Log file not getting smaller on Log backup - I have a database that is in full backup recovery model. When the log file is backed up the usage size is not getting smaller [ dbcc sqlperf(logspace) ] . For example, if the log file is 1000 MB, and 800MB is used, the expectation is when a log backup occurs, the usage will then […]
SQL Server 2019 - Development
Update particular record in a table - I need to update greatherthan8 (category) record to Missing (status) if the same member is in different (category) but having same (status) and that also only when they are  compliant. for example 123 PID i have both lessthan8 and greaterthan8 (category) but having same (status) that is compliant so for this member 123 for greaterthan8 […]
SSIS giving "Error converting data type varchar to float" error - issue resolved.
mysql query timeout upped but job still fails about same number of minutes in - hi, i changed my mysql based linked server's timeout to N'600' instead of N'0' but my job (sqlagent->ssis) goes down at about  the same number of minutes in as when i have it at n'0'.  the error i get is shown below. i'm using an odbc driver (mysql) installed on my sql server to contact […]
is it cache or something else - hi a few days ago i narrowed down the cause of a new problem in ssrs to 2 columns (of maybe 50) in a view.   nobody is claiming responsibility.  the calcs for both are hard to look at.  when i eliminated the 2 columns, the view ran in ssrs fine. if you haven't seen this […]
Reporting Services
Report Server Configuration Manager - The target principal name is incorrect SSL - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection I am able to log into the SQL Server in SSMS without checking […]
Report Server Configuration Manager - Change Database - SSL Error - I'm getting an ' SSL Provider, error: 0 - The target principal name is incorrect.). I'm trying to set the database in the configuration manager and when I click on 'Test Connection' or 'Next' in the 'Change Database' popup box, I get that error. Report Server Configuration Manager - Change Database - Test Connection. Anyone […]
SQL Server 2022 - Administration
Edition features - SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive to state that the enterprise features are not being used and we can downgrade to standard? This is across all sql versions...2008R2,2012,2014...2022 Are there more checks which need to be performed before we make an informed decision ? Thanks
SQL Server 2022 - Development
Internationalisation - Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a product for some time now that had an entirely UK-only customer base. The powers that be now want to flog it to Australia and the ROI. For one reason or another, there are a few places […]
XML data import with poor stored procedure performance (needs optimization) - Hello SSC! I have been tasked with optimizing a stored procedure the imports data from XML to SQL tables. This SP is executing many child stored procedures and is using dynamic SQL. So, as you can imagine, performance is awful. All of our data is imported through XML files and there are a lot of […]
 

 

RSS FeedTwitter

This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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.
[email protected]

 

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