Database Weekly

SQLServerCentral Editorial

Constant Azure Improvement

  • Editorial

This week I noticed a number of changes in the Azure platform from their change feed. Actually, every week has a crazy number of changes across the entire platform, but this week a number of these were related to data and databases. That isn't always the case, but I saw some interesting items. We have […]

5 (1)

2022-04-16

62 reads

SQLServerCentral Editorial

Document yourself out of a job

  • Editorial

Some organizations have policies in place to make sure that everything in their IT infrastructure is documented. There are runbooks, procedures, wikis, diagrams, charts, code comments, and more to make sure that knowledge is available if an employee leaves or when disaster strikes. Not only does the documentation exist, but it’s also organized and easy […]

2022-04-09

156 reads

SQLServerCentral Editorial

SQLBits Report

  • Editorial

Last week I attended my first in-person event in over two years. SQLBits, the largest data platform conference in Europe, was a hybrid event and marked the first time many of us met in person in ages. It was a huge success as folks from around the world gathered to learn...and celebrate! I heard several […]

2022-03-19

84 reads

SQLServerCentral Editorial

Please include your DDL

  • Editorial

I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, […]

2022-02-05

100 reads

SQLServerCentral Editorial

T-SQL Requires the Right Approach

  • Editorial

Some of the most problematic T-SQL code I’ve seen over the years originated because the developer approached T-SQL with techniques more suitable for developing applications. I often saw these issues in my consulting days and always took the opportunity to teach the customer instead of only fixing the problems. One reason is that SQL is […]

5 (2)

2022-01-15

197 reads

SQLServerCentral Editorial

Education to solve the tech skills shortage

  • Editorial

I’ve been teaching T-SQL to groups of students since 2014 at the non-profit LaunchCode in St. Louis. LaunchCode provides free tech training, paid apprenticeships, and career support to hundreds of people who have the ability and interest but not always the opportunity to land tech careers. For example, not having a college degree can eliminate […]

5 (1)

2021-12-31

306 reads

SQLServerCentral Editorial

One to many SQL Server books

  • Editorial

Back in the late 90s, I had one large book on my desk with everything I needed – or thought I needed -- to know about SQL Server. It covered T-SQL, installation, backups, security, and more. Over the years, Microsoft has added components like SQL Server Integration Services and features like windowing functions and improved […]

5 (3)

2021-12-11

267 reads

SQLServerCentral Editorial

PASS Data Community Summit 2021 Report

  • Editorial

The 2021 virtual PASS Data Community Summit was held from November 8th through the 12th. PASS Summit has always been the biggest yearly conference for database professionals, and this year’s virtual conference had over 18,000 individuals registered! If you signed up for the event, you may now stream the sessions on-demand. This is an exclusive […]

2021-11-20

210 reads

Blogs

Working with Neo4j Imports–I HATE CASE SENSITIVITY

By

I’ve been working to better understand graph databases and where they can be useful....

Daily Coping 8 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source

By

(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets,...

Read the latest Blogs

Forums

SSAS connection failures. Unable to read data from transport connection.

By ramana3327

Hi, Standalone default SSAS is installed. No issues connecting from SSMS on the server...

SCOM alert : Other processes use too much memory

By ramana3327

Hi , We have several SQL instances (200 servers). Some of them have SSRS...

Identifying Driver it is using

By ramana3327

Hi, We have SQL server installed on one server & SSAS stand-alone installation on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers