When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.
This article looks at what an average day of a SQL Server Data Architect looks like and some of the things you would need to as a Data Architect.
Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.
This article explores how to create and use views in SQL Server 2019 using SSMS.
This article will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.
Enterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently explore and analyze data at large-scale. CData Connect solves the challenge of data exploration and discovery through virtualized connectivity to data distributed across many data sources. In this article, we explore the Derived Views and Query Federation features […]
By Rob Sewell
Work smarter, not harder.
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
SQL is essential for modern businesses and applications that rely on data. It's a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers