Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.
2016-06-07
6,986 reads
Karthik provides a simple solution to querying a table that has comma separated values.
2016-06-06
8,568 reads
What is next for big data? Some experts claim that data "volumes, velocity, variety and veracity" will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does not take into account how data degrades over time. Analysis of historical data will always be with us, but generation of the most useful analyses will be done with data we already have. To adapt, most organizations must grow and mature their analytical environments. Lockwood Lyon shares the steps they must take to prepare for the transition.
2016-06-03
10,764 reads
In order to keep the demands of the job under control, any DBA needs to automate as many as possible of the suitable tasks that their role demands. What makes a task suitable? How do you judge whether it is worthwhile? Can we take a 'managed', consistent, decision? Joshua Feierman explains the practicalities with a real example.
2016-06-02
6,359 reads
In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.
2016-06-01
3,273 reads
For T-SQL Tuesday #78, Aaron Bertrand takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.
2016-05-31
3,857 reads
The most frustrating thing with any new system is often just working out how to connect to it. Oddly, you can’t use SSMS with SQL Data Warehouse, but it is fine with SSDT, SSIS, Power BI desktop, sqlcmd, BCP, and a range of Microsoft cloud services - there are PowerShell Cmdlets too. Rob Sheldon provides the details.
2016-05-30
3,054 reads
SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.
2016-05-27
5,062 reads
Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.
2016-05-26
4,366 reads
Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'. In this article, David Fitzjarrell takes a look at one such example in action.
2016-05-25
3,710 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Comments posted to this topic are about the item Making an Impression
Comments posted to this topic are about the item SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers