jamesserra.com

GENERAL
META
HTML
LINK ANALYSIS
SERVER
IP

Jamesserra.com receives any estimated 1,216 unique visitors and 521 unique page views per day. Revenue gained from these much visits may be $0 per day from various advertising sources. The estimated worth of site is $231. Similarweb global rank is 2,906,207. Maximum no. of users comes from .

Unified Layer is ISP, hosted on IP 67.222.38.97 in Country United States.

Website Age n/a
Alexa Rank no-data
Country United States
IP Address 67.222.38.97

META INFORMATION

Title

James Serra\'s Blog

Description

Career advice for the IT professional, as well as tips for SQL Server and Business Intelligence.

Keywords

career advice, sql server, business intelligence, SSAS, analysis services, james serra, SSIS, PerformancePoint, data warehouse, business intelligence consultant, sql server denali, sql server 2012, sql server data tools, power view

Content Type

utf-8

KEYWORDS AND KEYWORD DENSITY

No	Keyword	Website Count
1	Career advice	5
2	Business intelligence	5

GENERAL HTML INFORMATION

Type	Status
HTML 5
Responsive Website

HTML SIZE INFORMATION

Text / Code Ratio 38.72 %

jamesserra.com has a website text/code ratio of 38.72 %. Search engine crawlers tend to not pick up pages with inadequate content.

IMPORTANT HTML TAGS AND COUNTS

Titles

H11
H211
H317
H40
H50
H60

No	Text
1	James serra's blog

No	Text
1	Business continuity in sql database
2	Recovering a database
3	More adls gen2 enhancements
4	Upload files to adls gen2
5	Power bı faq
6	More azure blob storage enhancements
7	Build announcements: azure synapse analytics in public preview and more
8	Monitoring power bı
9	Query acceleration for adls
10	Accessing managed ınstance via ssms
11	Azure synapse analytics confusion

No	Text
1	Prepare for an outage
2	Failover to a geo-replicated secondary database
3	Perform a geo-restore
4	Perform post failover / recovery tasks
5	About james serra
6	Follow me!
7	Subscribe by email
8	Recent posts
9	Recent comments
10	Archives
11	Categories
12	Top posts & pages
13	Favorite blogs
14	Meta
15	ı’m a top 10 sql server blogger of 2018
16	ı’m a former sql server mvp
17	ı’m a rockstar blogger

Text Styling

STRONG49
B0
EM7
I0
U0
CITE0

STRONG

No	Text
1	Recovering a database
2	Prepare for an outage
3	Failover to a geo-replicated secondary database
4	Perform a geo-restore
5	Perform post failover / recovery tasks
6	Archive tier is now GA
7	Immutable storage (preview)
8	File snapshots (preview)
9	Static website (preview)
10	What is the best way to organize workspaces?
11	Should we have dev, test, and prod workspaces?
12	When you publish an app, is it always in the same dedicated capacity as the workspace? Wondering if you could have a workspace in dedicated capacity “A” and publish the app to dedicated capacity “B” (if you do not want people hammering the workspace to cause performance issues with people using the app)
13	Can you share datasets across workspaces that reside in different capacities?
14	In a deployment pipeline, can you have dev/test/prod in workspaces that are in different capacities?
15	How can you know about datasets that you don’t have access to? It would make sense to be able to search for a dataset and get a result back that the dataset exists but you need to request permission to use it
16	What is the differences in PowerQuery in PBI desktop vs PBI service (dataflows)?
17	Can you download a report into a pbix file?
18	How do we refresh a dataflow?
19	How do I monitor premium capacities?
20	How can I restore a deleted reports, workspace or dashboard?
21	How can I get an alert when a premium capacity hits a performance metric (i.e. when the CPU of a premium capacity hits 100% or a report takes more than a minute to execute)?
22	What are the differences in all the admin roles?
23	Why would you restart a Power BI Premium capacity?
24	Can I prompt for parameters in the Power BI Service?
25	Is it possible to change the region selection of a premium capacity after it is created?
26	Is there a way to see the permissions given to a published app?
27	What is he SLA of PBI and is there DR?
28	How can I see what new features are on the roadmap?
29	April 2020
30	September 2020
31	Blob index preview:
32	Geo-Zone-Redundant Storage (GZRS)
33	Account failover
34	Versioning preview
35	Point in time restore preview
36	Routing preferences preview:
37	Object replication preview:
38	Performance analyzer
39	Usage Metrics
40	View usage metrics report
41	Usage metrics
42	Query Diagnostics
43	Power BI Premium Metrics app:
44	Monitor Premium capacities
45	Data Profiling
46	Power BI Activity Log
47	Microsoft Cloud App Security real time user activity monitoring
48	Data protection metrics report
49	Multi-master cluster

No	Text
1	geo-restore
2	Recovery time objective (RTO)
3	Recovery point objective (RPO)
4	(last updated May 14, 2020).
5	Query Acceleration
6	serrami.public.c23ca324af.database.windows.net,3342
7	the v1, v2, and v3 in my diagram is not in any way officially part of the product naming and is just used in this blog

LINK ANALYSIS

Total Link Count: 530

Internal Link Count : 305

No	Text	Type
1	Skip to content	text
2	Home	text
3	FAQ	text
4	Presentations	text
5	Consulting	text
6	About Me	text
7	Contact Me	text
8	← Older posts	text
9	Business Continuity in SQL Database	text
10	July 20, 2020	text
11	James Serra	text
12	HA/DR for Azure SQL Database	text
13	Azure SQL Database high availability	text
14	Azure SQL Database disaster recovery	text
15	Azure SQL Database	text
16	SQLServerPedia Syndication	text
17	1 Comment	text
18	More ADLS Gen2 enhancements	text
19	July 6, 2020	text
20	James Serra	text
21	More Azure Blob Storage enhancements	text
22	Azure Data Lake	text
23	SQLServerPedia Syndication	text
24	Leave a comment	text
25	Upload files to ADLS Gen2	text
26	June 22, 2020	text
27	James Serra	text
28	Azure Storage tips	text
29	Azure Data Lake	text
30	SQLServerPedia Syndication	text
31	Power BI FAQ	text
32	June 8, 2020	text
33	James Serra	text
34	Power BI	text
35	SQLServerPedia Syndication	text
36	1 Comment	text
37	More Azure Blob Storage enhancements	text
38	May 25, 2020	text
39	James Serra	text
40	Query Acceleration for ADLS	text
41	Blob Storage	text
42	SQLServerPedia Syndication	text
43	Build announcements: Azure Synapse Analytics in public preview and more	text
44	May 20, 2020	text
45	James Serra	text
46	Azure Cosmos DB	text
47	Azure Synapse Analytics/SQL DW	text
48	SQLServerPedia Syndication	text
49	9 Comments	text
50	Monitoring Power BI	text

External Link Count : 225

No	Text	Type
1	high availability architecture	text
2	Temporal tables	text
3	Built-in automated backups	text
4	Point in Time Restore	text
5	restore a deleted database	text
6	database recovery time	text
7	restore a database to another geographic region	text
8	Azure SQL Database and Backups	text
9	Long-term backup retention	text
10	the Azure portal	text
11	Azure PowerSh****	text
12	Active geo-replication	text
13	Manage application upgrades	text
14	Auto-failover group	text
15	unplanned mode	text
16	Design an application for cloud disaster recovery	text
17	Elastic pool disaster recovery strategies	text
18	Recover a database in SQL Database from an outage	text
19	manual unplanned failover	text
20	Design an application for cloud disaster recovery	text
21	geo-restore	text
22	database-level firewalls	text
23	contained users	text
24	Overview of business continuity with Azure SQL Database	text
25	High availability for Azure SQL Database and SQL Managed Instance	text
26	Creating and using active geo-replication – Azure SQL Database	text
27	Use auto-failover groups to enable transparent and coordinated failover of multiple databases	text
28	Configure a failover group for Azure SQL Database	text
29	Restore your Azure SQL Database or failover to a secondary	text
30	Introduction to Azure SQL Database Auto-Failover Groups	text
31	Azure SQL Server auto-failover groups	text
32	Introduction to Azure SQL Database Auto-failover groups	text
33	ADLS Gen2	text
34	hot, cool, and archive	text
35	Lifecycle management	text
36	More info	text
37	form	text
38	More info	text
39	this form	text
40	More info	text
41	form	text
42	More info	text
43	ADLS Gen2 storage account	text
44	Azure Storage Explorer	text
45	row-level security	text
46	build permissions	text
47	auditing	text
48	Q&A	text
49	Quick Insights	text
50	5 Tips for Separating Power BI Datasets and Reports [VIDEO]	text
51	deployment pipelines	text
52	publis***ng an app	text
53	promote	text
54	certify	text
55	security whitepaper	text
56	https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-share	text
57	https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/cdm-data-integration/power-query-online	text
58	https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix	text
59	https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use#schedule-the-refresh-frequency	text
60	https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity	text
61	https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-portal	text
62	http://dataap.org/blog/2019/06/05/recover-restore-deleted-power-bi-workspace-step-by-step/	text
63	Power BI Sentinel	text
64	https://docs.microsoft.com/en-us/power-bi/admin/service-interruption-notifications#capacity-and-reliability-notifications	text
65	Azure Monitor integration	text
66	https://docs.microsoft.com/en-us/power-bi/admin/service-admin-administering-power-bi-in-your-organization	text
67	https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-restart	text
68	https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters	text
69	https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-parameters	text
70	https://docs.microsoft.com/en-us/power-bi/admin/service-interruption-notifications	text
71	https://docs.microsoft.com/en-us/power-bi/admin/service-admin-failover	text
72	online	text
73	PDF file	text
74	Power BI Release Wave	text
75	Azure Blob storage	text
76	announced	text
77	Lifecycle management	text
78	-	image
79	Manage and find data on Azure Blob Storage with Blob Index	text
80	Azure Availability zones	text
81	Zone redundant storage (ZRS)	text
82	secondary geo pair region	text
83	Disaster recovery and account failover	text
84	soft delete	text
85	Blob versioning	text
86	Blob Change feed, currently in preview	text
87	Point in time restore	text
88	Learn more	text
89	Object Replication doc***entation	text
90	Azure Blob Storage enhancing data protection and recovery capabilities	text
91	Microsoft Build	text
92	Azure Synapse Analytics	text
93	Azure resource providers and types	text
94	Synapse Studio	text
95	Collaborative workspaces	text
96	Distributed T-SQL Query service	text
97	SQL Script editor	text
98	Unified security model	text
99	Notebooks	text
100	Apache Spark	text
101	On-demand T-SQL	text
102	Code-free data flows	text
103	Orchestration Pipelines	text
104	Data movement	text
105	Integrated Power BI	text
106	doc***entation	text
107	PowerPoint deck	text
108	release notes	text
109	Workload Isolation	text
110	Updatable Hash Key	text
111	COPY statement for data loading	text
112	PREDICT Scoring	text
113	Bulk Load Wizard	text
114	DeltaLake Tables v0.6 support (in Spark and Data Flow)	text
115	SQL MERGE support	text
116	Column Encryption	text
117	COPY statement	text
118	Data loading strategies for Synapse SQL pool	text
119	“Developing end-to-end analytics solutions with the latest Azure Synapse features”	text
120	Try the latest Azure Synapse features with an Azure free trial account	text
121	Register for the virtual event “Azure Synapse Analytics: How it Works”	text
122	Step-by-step tutorial on securely and easily sharing data	text
123	Download the Synapse Getting Started Toolkit	text
124	What is Azure Synapse Link for Azure Cosmos DB (Preview)?	text
125	Azure Analytics: Clarity in an instant	text
126	Cosmos DB	text
127	Azure Cosmos DB analytical store	text
128	Azure SQL Database	text
129	Azure Database for PostgreSQL	text
130	Azure Database for MySQL	text
131	Connect to Synapse Link for Azure Cosmos DB	text
132	-	image
133	request units	text
134	Create Azure Cosmos containers and databases with autoscale throughput	text
135	Autoscale + serverless: new offers to fit any workload	text
136	Azure SQL Edge	text
137	Microsoft Build 2020 Book of News	text
138	Microsoft Build brings announcements for cloud data, analytics services, and intersection of the two	text
139	5 Reasons why Azure Synapse Analytics should be on your roadmap	text
140	Azure Synapse Analytics – First Impression – Part 1	text
141	Use Performance Analyzer to examine report element performance	text
142	-	image
143	Monitor usage metrics in the new workspace experience	text
144	Admin Usage Metrics	text
145	-	image
146	Query Diagnostics	text
147	-	image
148	Monitor Premium capacities with the app	text
149	Introducing Power BI Premium Capacity Metrics App as a template app	text
150	Power BI Premium Metrics app	text
151	What is Power BI Premium?	text
152	-	image
153	refresh summary	text
154	Monitor Premium capacities in the Admin portal	text
155	-	image
156	Data Profiling in Power BI (Power BI Update April 2019)	text
157	Data Profiling, Quality & Distribution in Power BI / Power Query	text
158	-	image
159	Introducing the Power BI Activity Log	text
160	Track user activities in Power BI	text
161	-	image
162	Getting Started with the New Power BI Activity LogAPI	text
163	Using Microsoft cloud app security controls in Power BI (preview)	text
164	-	image
165	Power BI administrators	text
166	enable data sensitivity labels in Power BI	text
167	Apply data sensitivity labels in Power BI	text
168	Data protection metrics report (preview)	text
169	-	image
170	HOW TO IMPROVE POWER BI PERFORMANCE – PART I	text
171	HOW TO IMPROVE POWER BI PERFORMANCE – PART II	text
172	Monitoring Power Query Memory Usage With Query Diagnostics In Power BI	text
173	What you need to administer Power BI	text
174	announced	text
175	Azure Data Lake Storage Gen2	text
176	Blob Storage	text
177	-	image
178	Azure Data Lake Storage Query Acceleration Public Preview	text
179	Azure Data Lake Storage query acceleration	text
180	Query Acceleration for Java and .NET	text
181	Filter data by using Azure Data Lake Storage query acceleration	text
182	Query acceleration SQL language reference	text
183	pricing model for Query Acceleration	text
184	SQL Server Management Studio	text
185	Azure SQL Database Managed Instance	text
186	VNET	text
187	here	text
188	announcement	text
189	Configure public endpoint in Azure SQL Database managed instance	text
190	-	image
191	-	image
192	Azure Synapse Analytics	text
193	-	image
194	join	text
195	video	text
196	Understanding Azure Synapse Analytics	text
197	-	image
198	-	image
199	-	image
200	Azure SQL Database Business Continuity Options – Curated SQL	text
201	A Power BI FAQ – Curated SQL	text
202	Chris Webb	text
203	Paul Randal	text
204	Brent Ozar	text
205	Mark Tabladillo	text
206	Marco Russo	text
207	James Beresford	text
208	Boyan Penev	text
209	Devin Knight	text
210	Thomas LaRock	text
211	Denny Lee	text
212	Thomas Kejser	text
213	Alberto Ferrari	text
214	Garrett Edmondson	text
215	Sean McCall	text
216	Dan English	text
217	Sal De Lorea	text
218	Jamie Thomson	text
219	Bill Anton	text
220	Entries feed	text
221	WordPress.org	text
222	-	image
223	-	image
224	-	image
225	Proudly powered by WordPress.	text