SQL Server High Availability and Disaster Recovery Plan
Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.
2021-08-06
Microsoft SQL Server
Power Apps Canvas Apps Examples
In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.
2021-04-15
Digital Event: Innovate Today with Azure SQL
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
2021-04-14
Digital Event: Innovate Today with Azure SQL
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
2021-04-12
Power BI Anomaly Detection
One of the problems with data analysis is the potential for anomalies that can skew results. In this article we look at a Power BI feature to detect anomalies and outliers in the data.
2021-04-09
Minimal Downtime Storage Migration of Large Databases
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2024-01-01 (first published: 2021-02-24)
7,667 reads
Learning SQL Server
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
2021-02-24
Implementation of Normalization in SQL Server
Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
4,539 reads
Power Query or SQL Server? Which, when and why
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
16,921 reads
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
2,106 reads
Blogs
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video...
T-SQL Tuesday #185–Being a Video Star
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
Building Resilience: Leadership Insights from Sports
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
Forums
Customer Service CS Flip
Layanan (resmi) Customer Service Flip Alpha di nomor 0821_64093578 telepon/whatsApp
Customer Service CS Flip
Layanan (resmi) Customer Service Flip Alpha di nomor 0821_64093578 telepon/whatsApp
Need help accessing and loading a temp table
I'm trying to dynamically create a temp table, basing the column names on another...
Question of the Day
The Long String
I have a table (dbo.beer) with this data:
| BeerID | BeerName | brewer | beerdescription |
| ----------- | -------------------- | -------------------- | ---------------------------------------------------------------------------------- |
| 1 | Becks | Interbrew | Beck's is a German-style pilsner beer known for its golden color, full-bodied taste, and a crisp, clean finish with floral and fruity hop aromas, brewed according to the German purity law |
| 2 | Fat Tire | New Belgium | Toasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced. |
| 3 | Mac n Jacks | Mac & Jack's Brewery | This beer erupts with a floral, hoppy taste, followed by a well rounded malty middle, finishing with a nicely organic hop flavor. Locally sourced two row grain and a blend of specialty malts give our amber its rich taste. |
| 4 | Alaskan Amber | Alaskan Brewing | Alaskan Brewing Amber Ale is an "alt" style beer, meaning it's fermented slowly and at colder temperatures, resulting in a well-balanced, richly malty, and long-lasting flavor profile with a clean, pleasing aftertaste. |
| 8 | Kirin | Kirin Brewing | Kirin Ichiban is a Lager-type beer, which means it is fermented at low temperatures and offers a light and refreshing texture with a smooth and balanced flavor. |
CREATE TABLE [dbo].[Beer] ( [BeerID] [int] NOT NULL IDENTITY(1, 1), [BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GOI run this code:
SET TEXTSIZE 20; SELECT b2.BeerName , b2.beerdescription FROM dbo.Beer AS b2; GOWhat is returned? See possible answers