We can now clearly see two opposing trends in the way SQL Server is being used in applications. The dumb database brigade regards SQL Server as simply a 'data dump'. The 'database fanatics' think SQL Server on its own can meet the needs of all but the most demanding applications. Can these opposing trends be reconciled? Tony Davis would like to think so.
In the recent installments of our "SQL Server 2005 Express Edition" series we have been discussing mechanisms that facilitate authentication of distributed systems participating in Service Broker conversations. This article discusses use of digital certificates in encrypting their content on the transport level.
Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the rescue with a simple guide that serves either to remind or educate us all!
Data warehousing author and expert, Vincent Rainardi, brings us a new article that looks at one of the most frequently used dimensions in Analysis Services.
Phil Factor talks a bit about the SQLServerCentral community and how we all get something different from it.
Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.
New features in SQL Server 2008 Reporting Services mean improved charting and increased memory. Learn more about SSRS performance upgrades in SQL 2008.
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
The NSE7_OTS-7.2 Practice Questions page is designed to help students and IT professionals prepare...
Comments posted to this topic are about the item The Vector Data Type
Comments posted to this topic are about the item What Power BI DirectQuery does...
What is the vector data type in SQL Server?
See possible answers