Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.
2014-11-25
7,702 reads
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?
2014-11-24
11,320 reads
It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.
2014-11-21
11,773 reads
Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.
2014-11-20
8,841 reads
Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.
2014-11-19
11,050 reads
Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.
2014-11-18
11,181 reads
It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.
2014-11-17
8,447 reads
What do you do when you want to receive critical server health alerts?
2014-11-13
8,936 reads
It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention and management of configuration information. Configuration information is also essential for audit, resilience, and support. The range of documentation varies widely with the database and its setting, but the underlying principles remain the same. Without appropriate configuration management, automation is likely to be futile.
2014-11-12
10,784 reads
You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.
2014-11-11
7,759 reads
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
This post shows you how to install containerd as the container runtime for Kubernetes...
Wa:083849450961 Jl. MP. Mangkunegara Jl. Villa Kenten No.20-21, 8 Ilir, Kec. Ilir Tim. II,...
Comments posted to this topic are about the item SQL Server Vector Support II
Comments posted to this topic are about the item Great Things
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers