As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

Now with SQL Server 2008, we are expected to download the samples from the codeplex.com web site. This makes sense to remove the dependency from the product. We don’t have to wait on a new product ...

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...