Sometimes it is necessary to search for specific content inside documents stored in a SQL Server database. Is it possible to do this in SQL Server? Can I run T-SQL queries and find content inside Microsoft Word files? Yes, now with SQL Server 2012 you can do a semantic search.
Today Steve Jones talks about the differences between development and production and how it can be good to spend a little doing the other type of work.
SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.
Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.
This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.
This Friday Steve Jones talks about training and employers, and who has the responsibility for your knowledge? Let us know if you think your employer shares the burden with you.
This white paper describes how to export master data from Microsoft SQL Server Master Data Services (MDS) using a subscription view, and how to import the master data into an external system using SQL Server Integration Services (SSIS). The white paper provides a step-by-step sample for creating a subscription view and an SSIS package.
A helpful guide to writing technical papers by focusing on the non-technical elements.
Steve Jones talks about the improvements in Hyper-V in Windows Server 2012. These days there isn't a good reason to avoid considering virtualization for SQL Servers.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Cara buka blokir Bank Permata (rekening/ATM/mobile) dapat dilakukan melalui PermataTel di 1500-111, whatsapp, 0821"...
Comments posted to this topic are about the item The New Wave of Security...
Comments posted to this topic are about the item There's Too Much to Learn
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers